Thanks,

Yes, this gets me started. I do have a question about updating multiple rows.

This example seems to only update one column in the target table.

Also the staging table will...

Here is a sample of the output I want to execute via @SQLstr

UPDATE JP_CDM.case_reopen_block_history SET ...

I have the following SQL that creates the output I need to capture in a variable like @SQLstr so that I can execute the string:

exec(@SQLstr)

But I get the error...

Thank you very much Lynn! 🙂

Here is the solution:

drop table #case_tmpTable

SELECT * INTO #case_tmpTable FROM [JP_CDM].[case]

where 1 = 2

ALTER Table #case_tmpTable

DROP COLUMN case_id

------------------------------------------------------

The code above creates the temp table structure based on the target...

Ok,

The solution is simple!

I just drop the column I don't need via the following:

drop table #case_tmpTable

SELECT * INTO #case_tmpTable FROM [JP_CDM].[case]

--where 1 = 2

ALTER Table #case_tmpTable

DROP COLUMN case_id

This removes...

Here is the proposed process:

1. Create a temp table with the structure of the target table (@SomeTable Name)

2. Apply the business rules to the incoming data and load the...