Looks like you want someone to do your homework.

If you want help, post what you're trying and specifics of how your efforts are not getting you the data you're expecting.

The Dictionary.com definition of kludge:

I would not...

GSquared (10/3/2012)

---

A WaitFor in such a process is commonly there to give the server a chance to finish other threads/processes in between loops.

However, on a process like this, if you...

while 1 = 1 loops just fine. It will break out of the loop when applicable because of the break statement.

My bad on @@ROWCOUNT ... that value should be...

Wow, they built a billion record heap? Ouch. Sorry man.

sql-lover (10/3/2012)

---

bt,

That's a very nice piece of code, thank you so much. However, I wonder how many locks (if one) it will create. Like I said, the production server has...

Maddave (10/3/2012)

---

Thanks guys, all very interesting stuff. I'm getting more in to how this application is implemented and it's becoming scary. As Sean Lange mentioned, the developers have...

aaron.reese (10/3/2012)

---

out of interest then; if I was selling books (ISBN, Author, Pages), wine (bottle size, ABV,Vinyard,grape,acidity) and shirts (material,collar type, sleeve length), how would you recommend storing the...

The term for the issue in your query that you're dealing with is that it is "non-deterministic". Although you experienced the same order of results in the past, there...

This is the kind of code I was referring to if you choose to go with a chunking process rather than BCP. We've had similar projects as yours and...

Depending on your timeline, you could do this with virtually zero downtime. Rather than doing a bulk copy, you could easily chunk this up since you're not looking for...

He said these are very big tables. Altering the column means that...

I'm not sure how logical this project is, but it seemed interesting to do this without looping. It was fun.

declare @b-2 bigint = 31;

declare @out varbinary(128) =...

declare @input int = 113804

-- these are the different parts that will be used

select @input / 10000

select (@input / 100) % 100

select @input % 100

-- SQL Server 2008 Query

select convert(time,...

One minor point ... even if you decide to use what they've established, you can make the inserts quite a bit more efficient by ditching the cursor loop. The...