USP_IDSETREGISTER_GETMETADATA

create procedure dbo.USP_IDSETREGISTER_GETMETADATA
(@ID uniqueidentifier)
with execute as caller
as
begin
    -- do work


  select
    [IDSETREGISTER].[STATIC],
    coalesce([ADHOCQUERYVIEWCATALOG].[MARTKEY], [MERGEQUERYVIEWCATALOG].[MARTKEY],'') as [MARTKEY],
    cast(case when [IDSETREGISTERMERGE].[ID] is not null then 1 else 0 end as bit) as [ISMERGE],
    [MERGESETREGISTER1].[STATIC] as [MERGESELECTION1STATIC],
    [MERGESETREGISTER2].[STATIC] as [MERGESELECTION2STATIC]

  from dbo.[IDSETREGISTER]
  left join dbo.[IDSETREGISTERADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
  left join dbo.[ADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[ADHOCQUERYID] = [ADHOCQUERY].[ID]
  left join dbo.[QUERYVIEWCATALOG] as [ADHOCQUERYVIEWCATALOG] on [ADHOCQUERYVIEWCATALOG].[ID] = [ADHOCQUERY].[QUERYVIEWCATALOGID]
  left join dbo.[IDSETREGISTERMERGE] on [IDSETREGISTERMERGE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
  left join dbo.[IDSETREGISTER] as [MERGESETREGISTER1] on [IDSETREGISTERMERGE].[SELECTION1ID] = [MERGESETREGISTER1].[ID]
  left join dbo.[IDSETREGISTERADHOCQUERY] as [MERGESETREGISTERQUERY] on [MERGESETREGISTERQUERY].[IDSETREGISTERID] = [MERGESETREGISTER1].[ID]
  left join dbo.[ADHOCQUERY] as [MERGEQUERY] on [MERGESETREGISTERQUERY].[ADHOCQUERYID] = [MERGEQUERY].[ID]
  left join dbo.[QUERYVIEWCATALOG] as [MERGEQUERYVIEWCATALOG] on [MERGEQUERYVIEWCATALOG].[ID] = [MERGEQUERY].[QUERYVIEWCATALOGID]
  left join dbo.[IDSETREGISTER] as [MERGESETREGISTER2] on [IDSETREGISTERMERGE].[SELECTION2ID] = [MERGESETREGISTER2].[ID]
  where [IDSETREGISTER].[ID] = @ID  

end