Heh... no worries... I've done the same thing when I got in a hurry   I even mispelled "RAND" in my first post...

You need to have another look there fella... I DID use NEWID() in my code... you didn't in your test. 

Then, you're kinda screwed so far as BCP goes unless you want to violate Microsoft Licensing (which I DON'T recommend).  Even with MSDE (which contains a copy of BCP), the...

Heh... you just got control of the situation and now you're going to "have some way for the developers to move approved code in when it is ready."??? 

That green code is sure hard to read, Lowell...

Like I said... just run BCP from the server pointing at the client using UNCs.

Heh... Gail, I'd love it if you could work for us... I'm just not the one doing the hiring.

Trust me on this, though... we have to constantly hit our developers...

Concur... mouse movements at 2AM are much more harmful to the mind than the body... I'd really like to see an article about being in the expert in the hot...

A bit disappointed in the commercialism used in the article... while the tool is powerful, it does not teach how to write SQL fast... and writing SQL fast is normally...

This isn't Oracle... stop using cursors.

Any feedback, Stephen?

Like Remi says... why use a cursor???

 UPDATE TABLE_1

    SET Rnd = RAND(CAST(NEWID() AS VARBINARY)) * 10000000000000

Any feedback, Anders?

Amrita?

I just love it when the OP doesn't respond... stab'n'grab.

There are a number of ways to returns trees in a high speed fashion in SQL Server 2000.... are you simply having performance problems or are you just concerned with...