Don't worry about posting too much data to help us understand - that's something that rarely happens here.

You need to post some table definitions, test data and expected in order...

And here I was, working out how to skip a column because I've been sent a csv file with 16 columns intended for a table that has 15...

Thank you for...

This Technet article is a good starting point - http://technet.microsoft.com/en-us/library/ms190768(v=sql.90).aspx

You can use ROW_NUMBER() to add a sequence number to detect duplicates.

A basic example of it is here - http://sqlrambling.net/2013/11/04/row_number-basic-example/

Dynamic SQL is executed by using 'EXECUTE' - http://technet.microsoft.com/en-us/library/ms188332.aspx

or

SP_EXECUTESQL - http://technet.microsoft.com/en-us/library/ms188001.aspx

You'll find plenty of articles on these commands within SSC, come back if you have further questions on this.

Your CREATE DATABASE needs to be Dynamic SQL if you're going to pass parameters like that.

Also, if you're trying to create a Database Snapshot then the syntax is a little...

One of my brothers works for a large supermarket chain and is already sick of Easter - the Easter Eggs arrived into the warehouse on Christma Eve!

Google "sql server 2012 new features" and follow the links.

Couldn't agree more - how you handle the failure can become more important than the failure itself.

I've let my subscription to Adobe expire because of the way they handled their...

Have you tried searching for that error?

http://support.microsoft.com/kb/916760

"This problem is most likely to occur if you start the SQL Server 2005 installation from a folder on a network share or on...

That isn't a rollback in the normal DB sense - something is running that modifies that table.

Your best bet is probably a server-side trace, have a look at this series...

There are several very good examples in Technet: http://technet.microsoft.com/en-us/library/ms189461.aspx

Another example, using it within Row_Number: http://sqlrambling.net/2013/11/04/row_number-basic-example/

Testing. If I'm testing something against a test database, by using Snapshots I can restore the data back to the state it was in a few seconds rather than the...

SQLPass 2014 paid.

And this time I won't go to the Cheesecake Factory and order the heaviest slice of cheesecake that they make:sick:

One of my enduring memories of Seattle, unfortunately.

You've posted this in the SQL 2008 forum but you're referring to SQl 2000 - which is it?

Time was only intoduced in the 2008 version, it is not valid in...