To give an example, to below gives some sample data, with representative names. It also gives details of the relationsips (via a foreign key). Then i go on to give...

I might be missing something, but i can't see any kind of relationship between properties and opportunities. How do you know a property is applicable to a opportunity (and vice...

First things first, is we need more detail. Secondly, let's start at the beginning, as resolving the first issue may resolve the rest. You state "Most of the databases are...

A CTE might work well here then. I've not used your above query, as I don't quite understand your goal, but this should put you on the right path:

Sounds like your process moving data from your staging table to your production table is just inserting all the data, it's not doing any checks for the existance. You'll need...

SQL Server 2012 does not support SSIS: https://msdn.microsoft.com/en-gb/library/cc645993(v=sql.110).aspx#SSIS

You'll need to use Standard or above.

I assume, that this value is therefore stored as a varchar? Also, just to confirm, are you storing them as dd-M-yy (08-9-17) or dd-MMM-yy (08-Aug-17) (note M returns the Month...

The sa account would link to the dbo user. the sa is the System administrator, and has the highest privileges available on the server. Part of that means that it...