In that case... I'm not sure it's any faster (haven't done the ol' million row test on this one), but it...

I was hoping the op would tell me... but Ok... what does the CLR actually do? Remember, I'm not much into GUI's or WebServices.

...and Jean-François came up with one of the very few places where a memory-only While Loop actually squeaks past the Tally table (at least on my machine, it does). ...

p.s. Wrapping the problem up in a couple of "Free Pizza" coupons and wrapping that in a cold case of beer would give me better incentive to look for...

Heh... what... you think I do a search for...

Haven't tried those yet, Noel... can you give us a quick "how to" on...

What would be even more interesting is finding out what the CLR actually does.

Heh... I'd have to say it's a real bugger for me. I don't know how you do it everyday. My hat's off to you.

phoqueme (1/27/2009)

---

When giving examples, there is no need to blunder through every possible case of Table Scans before "realizing" MS SQL will only use the index scan on the column...

Stop using SSIS for ETL. Use BULK INSERT and some good T-SQL programming, instead.

JROCK (1/27/2009)

---

Thanks Lynn for the quick response. I was thinking that we could do an update query to select all records that was less than 9 characters long. ...

What is the maximum number of spaces that could occur and are periods ever going to appear in the data?

Oh, yea... almost forgot. If you're going to allow end users to build their own queries through and ad hoc reporting tool, even if it's something as sophisticated as...

Excel... with pass through queries to views in the database.

I guess I should first say thank you for the wonderful acknowledgements. Thanks, Lynn.

It's also a real pleasure to read an article with a logical progression and a whole...