Hi, their is a Header with explanation , I just placed it in the wrong place as it's my first function.

If you click on my name or the title you...

When I used to Link Microsoft Access Front End to a SQL SERVER (many moons ago),

I moved Access Database to the Server and created short cuts to it on

the...

Ignore I found the answer thanks.

http://www.sqlservercentral.com/Forums/Topic1476134-3077-2.aspx

That really depends on your requirements and how that data is stored/represented on the front end. For example if you normalize the address information and link it with a fact...

Thanks Phil.

That's the plan,

However

If a company has a warehouse say in Southampton, and they were sending

packages from Manchester say every day/every hour.

The Manchester and Southampton addresses are going to...

Couldn't insert the image for some reason

See Below

Thanks for the work around.

Sorry I don't have any data/schema as it was just a general question

regarding an UPDATE statement with an OUTPUT Clause.

I wanted to do something like this

use tempdb

GO

CREATE TABLE...

LOL didn't notice that.

Great article though, I based My DW Incremental load around it.

Ignore pervious post accidently posted to the wrong thread.

Could you not use a cached Lookup on the IDs, as opposed to a Merge Join

and then use an SSIS script (gives you access to C# hashbytes function which isn't...

If I would use SSIS to do the compare, I would need a merge join to join the two scans from the tables which would mean the data needs to...

Jayanth and Eirikur: your delta proposals seem quite interesting.

How did you create the delta?

Using the EXCEPT operator? This might be quite slow on the larger tables (about 10 million rows)....

SQL Server Native Client 11.0 IS based on OLEDB technology not ODBC.

Make sure that your Query complies to OLEDB rules.

CREATE TABLE #Unify

(

ID INT IDENTITY(1,1),

Code CHAR(3),

DESCR VARCHAR(10)

)

CREATE TABLE #JKS

(

ID INT IDENTITY(1,1),

Code CHAR(3),

DESCR VARCHAR(10)

)

INSERT INTO #Unify

SELECT '002','HSBOM'

INSERT INTO #JKS

SELECT '001','LCC'

UNION ALL

SELECT '002','HHT'

UNION ALL

SELECT '003','ICH'

UNION ALL

SELECT '004','Unify'

SELECT u.ID, ISNULL(u.DESCR,'') + '...