when user upload document then document save in this table and set values as 3 means this is in pedning
DocID DocName UploadedDate Uploadfile DocTypeID DepID ApproveID UploadedBy UserID
36 erp system 2014-02-03 Presentation1.pptx 1 4 3 noreen 21
and when director approve/reject this document then approveid changes to 1 e.g approve
so i want to show when first user upload document and then he/she view documents that which documents are in peding ,approve and reject
this is sp which i try
ALTER procedure [dbo].[UserIDDoc] Go to the complete details ...