USP_RECORDOPERATION_SMARTFIELDINCLUDEINWAREHOUSE

CREATE procedure dbo.USP_RECORDOPERATION_SMARTFIELDINCLUDEINWAREHOUSE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @OLAPDATASOURCEID uniqueidentifier
)
as

    set nocount on;

    if @CHANGEAGENTID is null
        exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    insert into [OLAPDATASOURCESMARTFIELD] (
        [OLAPDATASOURCEID], 
        [SMARTFIELDID],                
        ADDEDBYID, 
        CHANGEDBYID, 
        DATEADDED, 
        DATECHANGED
    )
    select 
        @OLAPDATASOURCEID, 
        sf.[ID], 
        @CHANGEAGENTID, 
        @CHANGEAGENTID, 
        getdate(), 
        getdate()        
    from 
        dbo.[SMARTFIELD] sf
        left join dbo.[SMARTFIELDCATALOG] sfc on sf.[SMARTFIELDCATALOGID] = sfc.[ID]
        left join dbo.[RECORDTYPE] r on sfc.[RECORDTYPEID] = r.[ID]
        left join dbo.[OLAPDATASOURCESMARTFIELD] odsf on sf.[ID] = odsf.[SMARTFIELDID]
    where 
        sf.[ID] = @ID
        and
        odsf.[SMARTFIELDID] is null
        and
        r.[NAME] in ('Constituent','Financial Transaction Line Item')

    return 0;