Same thing, only more complicated .

Insert into tableX (col1, col2) values (1, 2)

Insert into tableX (col1, col2) values (3, 4)

Insert into tableX (col1, col2) values (5, 6)

Insert into tableY (col1, col2) values ('a', 'b')

Insert into...

Why are you splitting into 4 groups in (2, 6, 10, 14, 18, 22)?

Holly sh1t!! I need to get some networking skills like this .

Maybe there was a unique index that's been deleted.

Or did you change the context of the delete (likw now using access when the old app was in vb)?

I still need the script to insert the sample data.

Also you're aware that this system is denormalized (escalate1hours1, 2, 3)?

The problems comes from the fact that I don't know what application needs to do with the data, and where that data is sitting. The server, and the applications...

try this :

use pubs

go

Select * from northwind.dbo.Categories

It works, but I don't know enough about your design to make a final statement.

Can you show me the query that produces those results?

Or can you repair the data?

That's exactly the reason I stay way from this syntax...

I know the feeling .

You're idea is good, just need this tweak :

Select LEFT(PostCode, CHARINDEX(' ', PostCode) - 1) from dbo.YourTable where CHARINDEX(' ', PostCode) > 0

Now it works

... That can't be good for performance!!!

Have you tried with 'NE11AA'?

You can use the data of database B when you are in database A, so I definitly wouldn't copy all the data (especially if you have millions of rows).