UFN_IDSET_GETQUERYID

CREATE function dbo.UFN_IDSET_GETQUERYID (@IDSETID uniqueidentifier)
returns uniqueidentifier
with execute as caller
as
begin
    declare @QUERYID uniqueidentifier

    select 
        @QUERYID = 
            case 
                when IDSETREGISTERADHOCQUERY.ADHOCQUERYID is null then IDSETREGISTERSMARTQUERYINSTANCE.SMARTQUERYINSTANCEID
                else IDSETREGISTERADHOCQUERY.ADHOCQUERYID
            end
    from 
        dbo.IDSETREGISTER
    left join
        dbo.IDSETREGISTERADHOCQUERY on IDSETREGISTER.ID = IDSETREGISTERADHOCQUERY.IDSETREGISTERID
    left join
        dbo.IDSETREGISTERSMARTQUERYINSTANCE on IDSETREGISTER.ID = IDSETREGISTERSMARTQUERYINSTANCE.IDSETREGISTERID
    where
        IDSETREGISTER.ID = @IDSETID

    return @QUERYID
end