spDocUploadFiles

Parameters

Parameter	Parameter Type	Mode	Description
@ParentID	int	IN

Definition

Copy


                CREATE Procedure [dbo].[spDocUploadFiles](@ParentID int)
AS
select     DocUploadFiles.[ID],
        DocUploadFiles.[CID],
        DocUploadFiles.[Name],
        DocUploadFiles.[FileName],
        DocUploadFiles.[Description],
        DocUploadFiles.[ContentType],
        DocUploadFiles.[OwnerID],
        DocUploadFiles.[UploadDate],
        DocUploadFiles.[Approved],
        DocUploadFiles.[Size],
        [dbo].fnUserName(DocUploadFiles.[OwnerID]) as [UserName] 
from DocUploadFiles  
where DocUploadFiles.CID = @ParentID