spLoadRecord_DocUploadFiles

          CREATE procedure [dbo].[spLoadRecord_DocUploadFiles](@PKID int)
          as
          select 
              DocUploadFiles.[ID],
              DocUploadFiles.[CID],
              DocUploadFiles.[Name],
              DocUploadFiles.[FileName],
              DocUploadFiles.[Description],
              DocUploadFiles.[ContentType],
              DocUploadFiles.[OwnerID],
              DocUploadFiles.[UploadDate],
              DocUploadFiles.[Approved],
              DocUploadFiles.[Size],
              convert(image,null) as [Contents],
              [dbo].fnUserName(DocUploadFiles.[OwnerID]) as [UserName],
              DocUploadFiles.[Guid],
              DocUploadFiles.[INTRASHBIN],
              DocUploadFiles.[FOLDERID],
              DocUploadFiles.[CLIENTSITESID],
              DocUploadFiles.[URL],
              DocUploadFiles.[DISCOVERABLE],
              DocUploadFiles.[DISCOVERABLETITLE],
              DocUploadFiles.[DISCOVERABLESUMMARY]
          from DocUploadFiles  
          where DocUploadFiles.ID = @PKID