An alternative would be be have an XML column in the base table where user defined fields could be placed. This would give you the option to use indexes if...

Try splitting the MERGE out into its component INSERT, UPDATE and DELETEs.

https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/

I have just done a search and came across:

http://www.doogal.co.uk/AdministrativeAreas.php?district=E09000001

Your problem is that postcodes are designed to direct mail so postcode districts do not always tie up with geographic areas of administration.

I suspect you are going to need all...

Your description of what you want does not tie up with your results.

I agree with Sergiy, it is not complicated. Try playing with:

SELECT COALESCE(S1.PERSON, S2.PERSON) AS Person

,COALESCE(S1.STARTDATE, S2.STARTDATE) AS StartDate

,COALESCE(S1.END_DATE,...

This looks like a rather contrived example for a FULL JOIN to me.

The OP might like to look at the following article:

https://www.mssqltips.com/sqlservertip/2231/avoid-external-dependencies-in-sql-server-triggers/

Removed

There are plenty of articles on how to use Net Manager and set up an Oracle linked server.

Here is the first one I came across:

http://sqlmag.com/sql-server/connecting-sql-server-and-oracle-using-linked-servers

From the Windows menu:

Oracle - oraClient...

Configuration and Migration Tools

Net Manager

Then expand:

Oracle Net Configuration

Local

Service Naming

Highlight Service Naming and press the Green plus on the left

There could be a problem with parameter sniffing or the proc could have been compiled with old stats.

Try putting WITH RECOMPILE at the top of the procedure.

Sorry, I have just read this thread again.

I initially saw 12c and assumed you were trying to connect to Oracle.

You also mention mysql so I am now not sure what...

I have just had time to look where the Oracle client is.

It is winx64_12102_client.zip, near the bottom of the following page:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

When setting up a linked server to Oracle, I normally install the Oracle client, which can be obtained from the Oracle web site, on the SQL Server Box. (Make sure...

Try something like:

SELECT DISTINCT

local_net_address

,local_tcp_port

FROM sys.dm_exec_connections

WHERE local_net_address IS NOT NULL;