EA7_spGetAssignmentDocumentsForStudent

            CREATE PROCEDURE dbo.EA7_spGetAssignmentDocumentsForStudent
                @LibraryID int, 
                @OwnerID int
            AS
            BEGIN
                -- SET NOCOUNT ON added to prevent extra result sets from

                -- interfering with SELECT statements.

                SET NOCOUNT ON;

                SELECT 
                    f.ID, 
                    f.UploadDate, 
                    f.FileName, 
                    d.EA7ClassAssignmentID
                FROM dbo.DocUploadPart p
                    INNER JOIN dbo.DocUploadFiles f on f.CID = p.ID
                    INNER JOIN dbo.EA7_AssignmentDocuments d on d.DocID = f.ID
                WHERE 
                    p.ID = @LibraryID and
                    f.OwnerID = @OwnerID

                SET NOCOUNT OFF;
            END