USP_SIMPLEDATALIST_MKTGIFTRECORDSSOURCESMARTQUERY

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

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