USP_MKTSOURCEANALYSISRULES_LOAD

CREATE procedure dbo.[USP_MKTSOURCEANALYSISRULES_LOAD]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select 
    [MKTSOURCEANALYSISRULES].[ID],
    [MKTSOURCEANALYSISRULES].[RECORDSOURCEID],
    [MKTSOURCEANALYSISRULES].[QUERYVIEWSPECID],
    [MKTSOURCEANALYSISRULES].[TSLONG],
    [RECORDTYPE].[NAME] as [RECORDTYPENAME]
  from
    dbo.[MKTSOURCEANALYSISRULES]
    inner join [QUERYVIEWCATALOG] on [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] = [QUERYVIEWCATALOG].[ID]
    inner join [RECORDTYPE] on [QUERYVIEWCATALOG].[RECORDTYPEID] = [RECORDTYPE].[ID]
  where
    [RECORDSOURCEID] = @ID;

  return 0;