UFN_BUILDSELECTSQL

Returns the select sql for the given selection id.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@SELECTIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_BUILDSELECTSQL
(
    @SELECTIONID uniqueidentifier
)
returns nvarchar(max)
with execute as caller
as begin

    declare @DBOBJECTNAME nvarchar(128);
    declare @DBOBJECTTYPE smallint;

    select @DBOBJECTNAME =  DBOBJECTNAME, @DBOBJECTTYPE = OBJECTTYPE from dbo.IDSETREGISTER where ID = @SELECTIONID;

    if @DBOBJECTNAME IS NULL 
        BEGIN 
        RETURN '';
        END

    if @DBOBJECTTYPE = 1 
        begin
            set @DBOBJECTNAME = @DBOBJECTNAME + N'(';
            set @DBOBJECTNAME = @DBOBJECTNAME + N')';
        end;
    else 
        if @DBOBJECTTYPE = 2 set @DBOBJECTNAME = @DBOBJECTNAME + N'(''' + convert(nvarchar(36), @SELECTIONID) + N''')';

    declare @IDSELECTSQL nvarchar(max) = N' select SELECTIONS.ID from dbo.' + @DBOBJECTNAME + ' as SELECTIONS';

    return @IDSELECTSQL
end