Heh... thanks for the feedback, Phillip... I kinda figured it was something like that.  Every once in a while, I'll look at one of these posts, start writing code, go...

As the two links John posted suggest, add an IDENTITY column to your table and concatenate  with the string conversion of that.

Uhp... nope... don't need a temp table for this one, Phillip... and we don't need to go near INFORMATION_SCHEMA or SysObjects... and it flies even with lot's of data. 

Suryah,

Thank...

I don't think the author intended it this way, but to answer your question of "So what if parts are copied from BOL"? Because...

1.  Plagerism is in pretty bad form. ...

You'd have to store it as a BIGINT... most phone numbers are too big for just INT.  That would also guarantee numerics only.

Why do you need DTS to preserve the leading 0?  What are you using DTS for?  Are you trying to create an "output file" of some sort?  Why do you...

I agree with that!  Store the phone number as a string of digits only... the other kludge that needs to be considered is are any international numbers ever going to...

Spot on especially about testing (or the general lack, there of)... thanks for the feedback. 

Perfect, Mike... Thanks for the tip. 

And I see what everyone is talking about, especially you and Confucius247...   If you really want to get deeper, read the "Terms of Use"...

Move the COMMIT TRAN to before the SET statements OR modify the two SELECTs in the SET statements to ready uncommitted data with WITH (NOLOCK)...

A better question is, why are...

SELECT STR(0.00,10,2)

SELECT STR(.00,10,2)

SELECT STR(0,10,2)

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?