USP_SIMPLEDATALIST_SMARTQUERYINSTANCECATEGORYINUSE

CREATE procedure dbo.USP_SIMPLEDATALIST_SMARTQUERYINSTANCECATEGORYINUSE(@ONLYMOBILIZED bit = 0)
as
    select [VALUE] = '00000000-0000-0000-0000-000000000001',
        [LABEL] = '<No Category>'
    where exists(select ID 
        from dbo.SMARTQUERYINSTANCE 
        where QUERYCATEGORYCODEID is null
            and (@ONLYMOBILIZED = 0 or SMARTQUERYINSTANCE.MOBILIZE = 1))
    union
    select distinct QUERYCATEGORYCODE.ID as [VALUE],
        QUERYCATEGORYCODE.DESCRIPTION as [LABEL]
    from dbo.QUERYCATEGORYCODE
    inner join dbo.SMARTQUERYINSTANCE on QUERYCATEGORYCODE.ID = SMARTQUERYINSTANCE.QUERYCATEGORYCODEID
        where @ONLYMOBILIZED = 0 or SMARTQUERYINSTANCE.MOBILIZE = 1
    order by [LABEL]