@jeff: thanks for pointing out my own laziness 😉

@lowell: You code almost does what I need:

BULK INSERT [dbo].[CITIES_GEONAMES] FROM 'D:\US.txt'

...

Hi, thx for your reply. I set the new width to 150, but after import I get this:

Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for...

Thanks!

Great, thanks! 🙂

No, titles and id's are different in this case. But thats a good point because I DO want ALL records to be returned, even when the title's OR id's are...

Ok, I now have:

select userid,id,title from (

select id,title,userid from locations l

union all

select id,title,userid from artists a

union all

select id,title,userid from users u

) as info

group by userid,id,title

--having count(userid)>1

but as soon as I...

Thanks guys! Got it working! 🙂

Awesome! It works! 🙂

Sorry if I wasnt clear, but by this "what I'd rather not have to do is individually insert the column names that are to be selected and inserted.", I mean:

I...

Yes, its clear and it also ALMOST works...:)

my requirement is also that the records that will be deleted are inserted in another table (for backup purposes).

So, what I did is:

;with...

@GSquared: its like you read the mind of my boss...

He said the exact same, and after thinking of it...it does make way more sense! 🙂

So the code Mr...

@mister.magoo: Love the comments in your code 🙂

As you mentioned you do provide the ouput as well: output deleted.*

But im still unsure which command to use to select the records...

@GSsquared: your query:

;with DupeCheck as

(select row_number() over (partition by companyname order by ID) as Row, ID

from dbo.prospects)

delete from DupeCheck

where Row > 1

and ID not in (select...

Mister Magoo, that is indeed what the output is supposed to be (also my thanks to LutzM)!

I ran your query and it marks the correct records for deletion.

1 question:

you say...

Ok, I think we've concluded now (you guys mostly;) my code is horrible 🙂

Actually I just ripped it of some blog and used, since I didnt know cursors are that...