EA7_fnCountSubmittedStudentsForAssignment

            CREATE FUNCTION dbo.EA7_fnCountSubmittedStudentsForAssignment
            (
                @EA7ClassAssignmentID int
            )
            RETURNS int
            AS
            BEGIN

                DECLARE @n as int

                SELECT 
                    @n = COUNT(DISTINCT EA7RecordID)
                FROM 
                    dbo.EA7_AssignmentDocuments
                WHERE 
                    EA7ClassAssignmentID = @EA7ClassAssignmentID

                RETURN @n
            END