Is it just me or has Barry gone missing??

You need to connect to Integration Services on the server.

Just to be sure, is rowid unique?

You should be able to script your database for SQL Server 2005 to recreate the database structure in a SQL Server 2005 database and then use export data to transfer...

SQL Express is free, but if you want to experiment with all the features of SQL Server you can purchase SQL Server 2008 Developers Edition for about $50.00 USD. ...

Looks like you want the last day of the current month, correct? If so, try this:

select dateadd(mm, datediff(mm, 0, getdate()) + 1, -1)

It also depends on how many duplicate records vs uniqie records you have in the table. How many unique rows (based on email) are there in the table?

If I may, you may wish to start by reading about RESTORE DATABASE and RESTORE LOG in BOL (Books Online, the SQL Server Help System that you may access directly...

I guess it depends how random the random numbers really are in this case. Would probably need to see if there is a way to capture the distribution. ...

Nice bit of work there bitbucket. I'd have expected more duplicates in the shorter string with it only being six characters long.

What is the source of the data? Instead of a comma delimited file, could you get a pipe delimited file?

Or to use BULK INSERT in T-SQL. If the file is a CSV this should be relatively easy to accomplish.

I do have one request, please put together a small dataseet for each of your tables along with expected results based on the sample data so that when I put...

I don't have time right now, as I am at work, but if others will let me I'll take what you have given here and work up a set-based solution...

Well, I do need to ask a question. Why are using a cursor? Depending on what you are doing, it is probably 99.9% possible to replace your cursor...