EA7_spGetAssignmentDocumentsForStudentAssignment

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

                -- interfering with SELECT statements.

                SET NOCOUNT ON;

                SELECT 
                    f.ID, 
                    f.FileName, 
                    f.UploadDate, 
                    ad.EA7ClassAssignmentID 
                FROM dbo.DocUploadFiles f 
                    JOIN dbo.EA7_AssignmentDocuments ad ON f.ID = ad.DocID
                WHERE 
                    f.OwnerID = @OwnerID AND
                    ad.EA7ClassAssignmentID = @EA7ClassAssignmentsID

            END