Is there any possibility that you could add a RowVersion column to your source table?

This, in combination with your PK, should allow you to identify rows which contain one...

...

all of our guys have the redgate tools, if you write a "Select * into", hover over it, then it will allow you to generate a CREATE #Table script...

Are there any functions, views or stored procedures in the DB?

If these were written by someone who knows the schema, you may be able to glean some ideas about the...

I hate "where 1=0" - I ..use  "where @debugmode=1" and pass that in as a parameter. the number of times one of my devs has hardcoded "where 1=2"...

Could you use two copies of each table and use synonyms to switch to and fro' every day?

The users query the data using the synonyms & have no need to...

• This reply was modified 7 years, 1 months ago by Phil Parkin.

Shifting gears for a minute... does anyone have experience with BitBucket (source control) and Jira?  Rumor has it that they integrate seamlessly but have zero experience with either so...

• This reply was modified 7 years, 1 months ago by Phil Parkin. Reason: Fix typo

Your OrderRules table should be normalised.

OrderRulesId, AccountId, AllowedState

(One row per allowed state, per account.)

(State could, and probably should, also be normalised.)

With this in place, everything becomes much easier.

• This reply was modified 7 years, 1 months ago by Phil Parkin.

I don't think so.

Can you describe the reasons you think that this would be helpful to you?

IF TOTAL_BILL_AMT_PROD = NULL THEN NULL ELSE (TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD = O then 0 Else 1 ) ISNULL(TOTAL_BILL_AMT_PRD) == ""? NULL(DT_STR, 4, 1252) : ((DT_NUMERIC,10,2)TOTAL_BILL_AMT_PRD - DT_NUMERIC,10,2)TOTAL_BILL_AMT == 0...

What does adminstroedproc  do? Or should it be adminstoredproc ?

Is it returning anything? Presumably not, otherwise I would suggest using WITH RESULT SETS, which is the usual way of solving...

Please also try this ... you shouldn't need those casts:

TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD == 0 ? 0 : 1

What are the data types of TOTAL_BILL_AMT and TOTAL_BILL_AMT_PRD within the data flow?

Also, try removing the quotes throughout the expression – if the 0, 0 and 1 are supposed to...

Is this as part of a data flow? If yes, add a derived column to your data flow and put the calculation in there.

ExecuteSQL tasks do exactly what they say...

• This reply was modified 7 years, 1 months ago by Phil Parkin.

i think you need to execute a script after the dacpac deployment. a dacpac will create tables and objects, but there's no scripting involved, so no, no script can...

• This reply was modified 7 years, 1 months ago by Phil Parkin.

I cannot see how executing a SELECT query in a post-deployment script will achieve anything useful. Where are you expecting the SELECTed data to go?