That's a little different.  I thought you said random "values", not "strings".  Of course, you could convert the following to strings.

--===== Create the list of the first...

Hi all,

My need is to insert random value from predefined list of possible values. It's data obfuscation project, thus no strict rules what value should be, rather it should...

And there the man is!  😀  Go for it, Scott!

You need to contact the people in charge of providing the necessary permissions.

Your indexes on the temp tables are still incorrect.  You're joining them by ID, not col1 and col2.  And, they should be Clustered Indexes.  At least that's why I see...

• This reply was modified 6 years ago by Jeff Moden.

Have you ever tried to shoot an arrow through the hole of a donut rolling down a hill from a quarter mile away?  That's how I'm starting to feel with...

No but, if you're having difficulties, I've tested the following link and it works although I've not actually attempted a download from that page.

https://www.powershellgallery.com/packages/dbatools/1.0.104

The table contains error message numbers and the description, which is the text of the error message from the sys.messages catalog view. Where applicable, the error number is a...

Ok.  That's a bit different than what you originally posted and I somewhat agree with the premise (it's called "Divide'n'Conquer"), although I question why even with a 100 million rows,...

I can only imagine that someone is starting an explicit transaction in the code and then using a mixed bag of SELECT, UPDATE, and possibly INSERT.  The only thing I...

I can think of one possible reason but let me ask you... why has someone made the code so that it first populates and interim "process" table only to turn...

Just to make one clarification....

Nothing... I mean ABSOLUTELY NOTHING gets done by me until I have that first cup o' Joe. 😀  Even my servers understand that. 😀

Great example of why you wouldn't, at least initially, point someone new to geometry to the Wiki article you sighted to explain what a square is.

Understood and appreciated on the...

Ok... that  explains why Bill's good code worked.  Thanks for coming back with that.

Hi Jeff, The second  code option works exactly as I need it. I Saw Bill's first which also works so I marked that as the answer but wanted to...