You're right, sorry. I misread the article to mean ditch the dupes.

My bad, in a hurry while trying to do actual work. 🙂

Admittedly, I didn't comb through the rules. I just threw together the code to perform the "impossible delete". 🙂

create table #tab (lname varchar(5), age smallint, sex char(1))

insert into #tab (lname, age, sex) select 'ABC', 24, 'M'

insert into #tab (lname, age, sex) select 'ABC', 24, 'M'

insert into #tab (lname,...

Regarding upgrading to 64bit, we've seen some massive performance increases here at work.  We've got a monthly process that on a 4 CPU Server with 16 Drives (mostly RAID 5)...

Lawnmower man, yeah, that's on my list too.  I forgot about that one (although I do own the DVD).

These are some of my favs

• Antitrust
• Pirates of Silicon Valley
• Philadelphia Experiment

We've got 10 licenses for it.  I tried about 10 different client apps / web based apps, and DWE was by far the most polished.  Their support is very good. ...

http://www.theserverside.net/news/thread.tss?thread_id=36510 ?

This thread got a little off topic, but I thought I'd report back with the progress I've made so far, and get feedback on thoughts/suggestions.

The Populate tab is used to...

Deciding which one does the writing is a matter of preference.  I'd lean toward the proc existing in DB2 simply because I'd rather all data manipulating procs reside in the database...

If both databases are on the same server, just write a stored procedure in DB2 that selects from DB1, and inserts into DB2, and call that proc from your application.

Don't return...

OSQL?

SQLCompare

It's a utility by Red-Gate software, and works very well.

VB

I'm contemplating porting it over to TSQL, but of course VB would still be required for the front end (or a web-based version).

I'm also thinking about being able to expand...

Ok...here's where I'm at so far....

http://www.themintons.org/work/procdoc.jpg

Note that this was all auto-generated, and so far, I haven't found where it's missed anything yet.