Still, Remi is correct... it will affect even a system time test because of the distribution unless you know for sure that the distibution of the actual data will be...

NOW I remember why I never looked at BOL 2005 ... Microsoft pushes the .NET stuff down your throat even on simple documentation...  BOL 2005 wants me to install the...

Thanks for the tip... I've not seen BOL 2005 so I couldn't tell just by reading the article... I'll check it out...

Thanks for the posted code.... still, why do you need to manufacture 10 rows for each row in the source table?

Yeah... and how many rows did you ultimately end up with?

Hang the typo's!!  There aren't that many and it's very obvious what they are/should be.  Heck, I've seen more errors in published books that have supposedly been professionally proof-read and...

This looks like a homework question and you are trying to get someone else do the work.

I'll drink to that!

Steve,

I gotta ask... you're saying that you basically want to copy all of table A into table B 10 times (regardless of the loop you requested)???

Why?  Not trying to be a smart guy here but why do you want to do such a conversion?  A lot of times,...

Heh... better late than never...

That, my old friend, is the reason I won't bet you... neither of us got this far being the fool...

Only after I know the answer for sure

Nothing a little self join correlated subquery magic can't fix... works in the grid or text modes...

--===== Supress the auto-display of rowcounts for appearance

    SET NOCOUNT ON

November 27, 2006 at 1:07 am