UFN_MKTSELECTION_EXISTS

CREATE function dbo.UFN_MKTSELECTION_EXISTS
(
  @ID uniqueidentifier
)
returns bit
as begin
  declare @ret bit;

  if exists(select top 1 1
            from dbo.[IDSETREGISTER]
            left join dbo.[IDSETREGISTERADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            left join dbo.[IDSETREGISTERSMARTQUERYINSTANCE] on [IDSETREGISTERSMARTQUERYINSTANCE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            where [IDSETREGISTERADHOCQUERY].[ADHOCQUERYID] = @ID
            or [IDSETREGISTERSMARTQUERYINSTANCE].[SMARTQUERYINSTANCEID] = @ID
            or [IDSETREGISTER].[ID] = @ID)
    set @ret = 1;
  else
    set @ret = 0;

  return @ret;
end