yes thats correct but i want to do multiple ones at the same time, i.e. hong kong, singapore, monaco. these are all stored in the joining table but still not...

but even with the joining table de-duped it still produces the same count. Does it matter if the original table i am trying to update to NULL has dupes? i.e....

ok i will select distinct from that table and create a new table and then use that one.

Thanks for all your help

oh ok, so if if de-dupe my connecting table then it should update fine?

so are you saying my update statement will never update what i want to (i.e. the select statement)

ok i have dupes in the staging table but surely this should not matter, when it sees Singapore in the staging table and in the update table then it should...

yes they are im afraid

thanks for this, but both of the statement run fine but i am gaining different results when i am expecting the same number of records

ok, i do know a lil SSIS but what flow items do i use?

at the moment, through import data tool i can only import a file one by one but i would like to do all at once so i dont to do...

well thanks for all of your replies but i have just started using sql so am a little rusty on the syntax ect.

yes pretty much meaningless, what does that statement actually do though?

'id' does mean something but i have 2 tables with results in that i want to amalgamate but they both...

please see my posts above, i do not want duplicates but need to set the id sequential starting from 1000000

i used this code to do this:

DECLARE @SourceID INT;

DECLARE @Counter INT;

SET @Counter = 1;

DECLARE ins_accounts CURSOR

FOR

SELECT id FROM attributes

OPEN ins_accounts

FETCH NEXT FROM ins_accounts

INTO @SourceId

WHILE @@FETCH_STATUS = 0

BEGIN

...

yes this is correct; so how do i make the id sequential starting from 1000000? so i do not have any duplicates