USP_SIMPLEDATALIST_MKTMEMBERSHIPRECORDSSOURCESMARTQUERY

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTMEMBERSHIPRECORDSSOURCESMARTQUERY]
(
  @RECORDSOURCEID uniqueidentifier = null,
  @RECORDTYPEID uniqueidentifier = null
)
as
  set nocount on;

  if @RECORDSOURCEID = '00000000-0000-0000-0000-000000000000'
    set @RECORDSOURCEID = null;

  if @RECORDTYPEID = '00000000-0000-0000-0000-000000000000'
    set @RECORDTYPEID = null;

  -- get the valid membership record types for the record source

  declare @VALIDRECORDTYPES table([ID] uniqueidentifier, [NAME] nvarchar(300));
  insert into @VALIDRECORDTYPES
    exec dbo.[USP_SIMPLEDATALIST_MKTMEMBERSHIPRECORDSOURCERECORDTYPES] @RECORDSOURCEID, @RECORDTYPEID;

  -- get the smart queryviews with the valid record types

  select distinct
    [SMARTQUERYCATALOG].[ID] as [VALUE],
    [SMARTQUERYCATALOG].[NAME] as [LABEL]
  from dbo.[SMARTQUERYCATALOG]
  inner join @VALIDRECORDTYPES as [VALIDRECORDTYPES] on [VALIDRECORDTYPES].[ID] = [SMARTQUERYCATALOG].[RECORDTYPEID]
  order by [SMARTQUERYCATALOG].[NAME];

  return 0;