UFN_MARKINGCOLUMNSET_GETNAME

            create function dbo.UFN_MARKINGCOLUMNSET_GETNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(250)
                as
                begin
                    declare @NAME nvarchar(250);

                    SELECT @NAME = (MCS.NAME + ' - ' + MC.DISPLAYNAME)
                     FROM MARKINGCOLUMN MC
                    INNER JOIN MARKINGCOLUMNSET MCS ON MC.MARKINGCOLUMNSETID = MCS.ID
                    WHERE MC.ID = @ID

                    return @NAME;
                end