UFN_CAMPAIGNSUBPRIORITY_GETNAME

                CREATE function dbo.UFN_CAMPAIGNSUBPRIORITY_GETNAME (
                    @ID uniqueidentifier
                ) returns nvarchar(100)
                as begin

                    declare @NAME nvarchar(100);
                    set @NAME = '';

                    select
                        @NAME = CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION
                    from
                        dbo.CAMPAIGNSUBPRIORITY
                        inner join dbo.CAMPAIGNSUBPRIORITYNAMECODE on CAMPAIGNSUBPRIORITY.CAMPAIGNSUBPRIORITYNAMECODEID = CAMPAIGNSUBPRIORITYNAMECODE.ID
                    where
                        CAMPAIGNSUBPRIORITY.ID = @ID;

                    return @NAME;

                end