Expanding upon SQL Kiwi reply - read this

http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx

Scroll down to about the middle of the page to see the explanation.

Jason - nice question

To assist those who desire to assist you, could you supply a short sample of the "list of data" that you need to insert.

R_Casey (9/21/2012)

---

I would like to upgrade my free 2008 r2 with advanced tools to the 2008 r2 developer edition. I understand there is a cost involved but need to know...

SQLRNNR

Targeting Joe and baiting him really needs to stop. And the same can be said of anybody else that has been personally attacked or been the recipient of piling on....

Luis Cazares (9/21/2012)

It would have been great to understand the difference between row-by-row programming and set based programming (or procedural language and declarative language). It would be important to notice...

It might be useful for you to read:

Title: Finding Gaps in a Sequential Number Sequence

http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582

And pay particular attention to the comments on the article by Jeff Moden, and all the...

In addition to what Hugo Kornelis supplied here is a reference listing the default collations for all languages and countries.

Default Collations in SQL Server Setup

http://msdn.microsoft.com/en-us/library/ms143508(v=sql.105).aspx

Do not know if this will do exactly what you want to do, but read here:

http://msdn.microsoft.com/en-us/library/ms181714(v=sql.100).aspx

Try reading this link:

http://decipherinfosys.wordpress.com/2008/11/12/a-useful-undocumented-function-fn_dblog/

If it helps or does not help please post back to let others know.

For those who are curious on how to change the batch terminator:

http://stackoverflow.com/questions/2299249/what-is-the-use-of-go-in-sql-server-management-studio

Best to copy and paste the above link rather than direcly clicking on it.

Nice simple straight forward question - glad I remembered the correct answer from a long, long time ago.

I know it is still early and not too many have attempted to...

Thanks -- Nice question an addition thank you for the extra information in the explanation of the correct answer ...

Is this what you need to do ?

SELECT 2.86 /1 - 2.86 % 1

...

call.copse (9/8/2012)

---

I think I have followed a similar trajectory to Phil. I have spent (literally) years writing specifications in the olden days. We spent approximately 40% on the project time...