add pending column in asp.net

docid docname file documnettype deptype status
1    abc      abc.pdf  pdf        finance  pending

create procedure sppendingfilesss
as
select DocumentInfo.DepID,DocumentInfo.DocName,DocumentInfo.Uploadfile,DocType.DocType,Department.DepType,ApproveType.ApproveType
from DocumentInfo inner join DocType on DocumentInfo.DocTypeID=DocType.DocTypeID inner join Department on DocumentInfo.DepID=Department.DepID
inner join ApproveType  on DocumentInfo.ApproveID=ApproveType.ApproveID  and (ApproveType.ApproveType=2)