USP_MKTSOURCEANALYSISRULEFIELDS_LOAD

CREATE procedure dbo.[USP_MKTSOURCEANALYSISRULEFIELDS_LOAD]
(
  @SOURCEANALYSISRULEID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSOURCEANALYSISRULEFIELDS].[ID],
    [MKTSOURCEANALYSISRULEFIELDS].[NAME],
    [MKTSOURCEANALYSISRULEFIELDS].[QUERYVIEWCATALOGID],
    [MKTSOURCEANALYSISRULEFIELDS].[QUERYFIELD],
    [MKTSOURCEANALYSISRULEFIELDS].[SEQUENCE],
    [MKTSOURCEANALYSISRULEFIELDS].[ISACTIVE],
    [MKTSOURCEANALYSISRULEFIELDS].[PURPOSE],
    [MKTSOURCEANALYSISRULEFIELDS].[SMARTFIELDID],
    [MKTSOURCEANALYSISRULEFIELDS].[ISCUSTOM],
    [MKTSOURCEANALYSISRULEFIELDS].[DBOBJECTNAME],
    [MKTSOURCEANALYSISRULEFIELDS].[ADHOCQUERYID],
    [MKTSOURCEANALYSISRULEFIELDS].[VIEWPATH],
    [MKTSOURCEANALYSISRULEFIELDS].[CACHETABLECOLUMNNAME],
    [MKTSOURCEANALYSISRULEFIELDS].[ISIDSET],
    cast((case when [SMARTFIELD].[USEVALUEGROUP] = 1 and [MKTSOURCEANALYSISRULEFIELDS].[QUERYFIELD] = 'VALUEGROUP' then 1 else 0 end) as bit) as [SMARTFIELDUSESVALUEGROUP],
    [MKTSOURCEANALYSISRULEFIELDS].[QUERYABLE]
  from dbo.[MKTSOURCEANALYSISRULEFIELDS]
  left join dbo.[SMARTFIELD] on [SMARTFIELD].[ID] = [MKTSOURCEANALYSISRULEFIELDS].[SMARTFIELDID]
  where [MKTSOURCEANALYSISRULEFIELDS].[SOURCEANALYSISRULEID] = @SOURCEANALYSISRULEID;

  return 0;