UFN_QUERYVIEW_OR_SMARTQUERY_GETNAME

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



                create function dbo.UFN_QUERYVIEW_OR_SMARTQUERY_GETNAME(@ID uniqueidentifier)
                returns nvarchar(255)
                with execute as caller
                as
                begin
                    declare @NAME nvarchar(255) = '';

                    with [CTE] as
                    (
                        select QUERYVIEWCATALOG.DISPLAYNAME [NAME]
                        from dbo.QUERYVIEWCATALOG
                        where ID = @ID

                        union all
                        select SMARTQUERYCATALOG.NAME 
                        from dbo.SMARTQUERYCATALOG
                        where ID = @ID

                    )
                    select top 1 @NAME = NAME 
                    from [CTE]

                    return @NAME;
                end