Using ROW_NUMBER() to merge data

I just tackled a problem using SQL's ROW_NUMBER() function, and I'm happy with how it turned out.  It would have been pretty tricky in SQL 2000. The problem at hand was merging 2 sets of data, copying data from one account into another account, where the records don't already exist. ... [Read More]