EA7_spGetAssignmentDocumentsForAssignment

            CREATE PROCEDURE dbo.EA7_spGetAssignmentDocumentsForAssignment
                @EA7ClassAssignmentID int
            AS
            BEGIN
                -- SET NOCOUNT ON added to prevent extra result sets from

                -- interfering with SELECT statements.

                SET NOCOUNT ON;

                SELECT 
                    df.OwnerID,
                    ad.EA7RecordID,
                    df.ID,
                    df.FileName,
                    df.UploadDate
                FROM 
                    dbo.EA7_AssignmentDocuments ad
                    INNER JOIN dbo.DocUploadFiles df    ON df.ID = ad.DocID
                    INNER JOIN dbo.ClientUsers cu       ON cu.ID = df.OwnerID
                WHERE
                    ad.EA7ClassAssignmentID = @EA7ClassAssignmentID
                ORDER BY
                    cu.LastName, cu.FirstName, df.UploadDate

            END