Hi Andrey,  It turned out to be a little bit more subtle than that.

I eventually traced it to the account setup.  One was set to Language =  British English and...

your problem is going to be referential integrity.  where you have foreign keys you will need to identify all of the dependent records.
If you are building a test or...

I think you will be OK with the suggestion above as long as the sheets follow a naming convention or you can iterate through the sheet names from another data...

@mike01

I expect the OP wants to always have the hash value in the same place so that queries are consistent - you can pretty much lift...

forSalePropertyCampaignList is an array [  ]   of objects { } rather than an object itself, therefore you need to reference the first element of the array [0] - arrays are...

SSIS and Excel do not play nicely.  Can you get the data from the original source rather than from Excel.

Excel will generate errors you can't program for in...

HI Peter.
I agree that SSIS does tend to make simple things complicated but it also makes REALLY complicated things less complicated when you get really under the hood.

Although it has gone quiet from the OP, Mail Merge, especially MS Word does not like nested data sets and most commercial mailing houses seem to struggle with it too. ...

Have a look at the following:

BIML (Business Intelligence Markup Language) which is an add-on for SSDT and helps to scaffold out SSIS packages based on sys metadata -...

EAVs can be a good way to scaffold an application until the users understand what they want as it gives ultimate flexibility on the data management side with 'relatively' little...

The one that freaks me out is the nested join syntax

SELECT
        A.something
        C.anotherThing
FROM
        TableA...

YES, you need to abstract the logic to make it easier to understand, maintain and test.

My first reaction would be to move the logic to a function as...

Of course I meant

(case.qty * base/isMultiplier * base.qty) + (ABS(base.isMultipliler-1) * base.qty / case.qty)

Either the multiplier or divisor will equate to 0 and the other will...

Why not create synonyms?

Synonyms are awesome because you can create them to have the same name in your target database as they are called in the source database...

It feels to me like this should be enforced by the application or business layer rather than in the database. Probably the simplest way to do it would be to...