DAMN -- got it wrong! Know why? Because I over-thought the answer: I though that since the counter (@i) started at 0 and incremented to 499, there would...

THIS is why I play this silly QotD game -- today I learned something completely new about the LEN() function. Very Nice.

Here's a possibility: "(NOTE: If you put your cursor over the link and nothing happens, try holding down the CTRL key)"

Quite simple, actually.

NB: I love people who say things like...

Fool's Reminder (to myself): if you have to say something bad / negative / contrary, don't forget to mention The Good Stuff as well. That's the "spoonful of honey...

I read those posts, and agree that some of then are ... off-base. But it's a little unfair of you to lump all such posts together. Surely you...

"Squeaky whining noise" ... huh?!

I got nothing -- no "popup instructions", no new tab, nada. If I Ctrl-Click (like others have done), I get the new tab, but the question didn't say that.

Either...

AH -- now I get it (thank you Oleg and Gennadiy). Here's the source of my confusion: I was thinking that this ...

insert into #funny_Test

exec(@Sql_str)

... resolved into this...

I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before actually studying the...

I have two "toasters":

1. CutePDF -- it's been years since I worked with a computer that I didn't install this on.

2. WordPad -- it's a step above NotePad, but loads...

I recently implemented a solution to this problem, and used (quite reliably) a combination of Jobs on the SQL Servers and DOS-based batch files (with Xcopy commands).

We took it one...