UFN_STUDENTADVISOR_GETFIRSTID

        create function dbo.UFN_STUDENTADVISOR_GETFIRSTID
        (
         @STUDENTPROGRESSIONID uniqueidentifier
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @STUDENTADVISORID uniqueidentifier;
            set @STUDENTADVISORID = (select top 1 dbo.STUDENTADVISOR.[ID] from dbo.STUDENTADVISOR where dbo.STUDENTADVISOR.[STUDENTPROGRESSIONID] = @STUDENTPROGRESSIONID)
            return @STUDENTADVISORID
        end