Sorry the table has some columns that I didn't include originally because they weren't part of the problem.

create table #DownloadCode

(

dlc varchar(14) not null,

dlcmembernumber numeric(13,0),

dlcdatereceived...

Jeff,

I don't get what you are saying. What am I supposed to select into the new table?

In writing the cursor for this I found the best way was to just update the download file with the member number it got assigned to so I didn't have...

I don't know where the OP is but from the original request it loks like you need the index on the dm and dm2 fields. Those are is Dual...

Yes one code per person, one person per code. There will be more codes than people as they are created in batches.

It doesn't matter which code gets assigned to which member. There is no relation until the code is assigned. It only matters that once it is assigned it...

one more step from Greg's code is to update the #mergelist table mergeid with the identity from the dups table joined on the double metaphone fields

I didn't see it mentioned here but your database must be in 80 compatability for the collate to work in a select statement. I spent some time trying to...

That is the boat I am in but after researching the process for converting master, model, and tempdb to the old collation I am interested in seeing if there are...

We like to say the same thing about skeet and sporting clays...

What about Dr. Xavier's computer in X-men.

I just went throug a similar situation except mine was a new employee I hired rather than an inheritance.

I hired my second choice because I couldn't afford my first choice....

What type of audit is this? Security or compliance? Have they had this audit before and if so what were the results? If we have results from a...

socket.Open "GET", "http://www.website.com/page.html", False, "username", "password"

OK then what we have should work. By saying tableB.guid is null it will exclude all records where there is a match between table A and Table B...