UFN_ISBUILTIN_WEALTHSOURCE

Determines if a wealth source is built-in.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCE	nvarchar(100)	IN

Definition

Copy



            create function dbo.UFN_ISBUILTIN_WEALTHSOURCE(@SOURCE nvarchar(100)) 
            returns bit
            as begin
                declare @ISBUILTIN bit;
                set @ISBUILTIN = 0;

                select
                    @ISBUILTIN =WEALTHSOURCE.ISBUILTIN
                from
                    dbo.WEALTHSOURCE
                where
                    WEALTHSOURCE.SOURCE = @SOURCE;

                return @ISBUILTIN;
            end