USP_SIMPLEDATALIST_MKTRECORDSSOURCESMARTQUERY

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTRECORDSSOURCESMARTQUERY]
(
  @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 record types for the record source...

  declare @VALIDRECORDTYPES table([ID] uniqueidentifier, [NAME] nvarchar(300));
  insert into @VALIDRECORDTYPES
  exec dbo.[USP_SIMPLEDATALIST_MKTRECORDSOURCERECORDTYPES] @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;