Whups... I can't make it next month ... I'm going to be in ummmm Bolivia... yeah that's it... outsourcing! :hehe:

Thanks, Flo 🙂

Derek, please don't feel you have to apologize. That needed to be tested. As usual, the answer is "It depends." The point...

You don't really have the kind of control you do in Excel. However, after the convert, you already have it in string format. All you have...

Thanks everyone, I truly hope I can be in the audience for some of your presentations.

One idea worth serious consideration is whether or not you are willing to upgrade to SQL 2008, now that SP1 is available. Sparse columns sound like the...

What is the deadline for registering as a mere attendee?

I'm working on getting my company to let me make a trip this year.

There is another option. Write the output to a table within the stored procedure and pass the name of that table back as an output parameter. ...

DOH! 😛

I think it's buried in all of Flo's posted code here:

http://www.sqlservercentral.com/Forums/FindPost701763.aspx

I think it's posted earlier in the thread, Lynn. If I find it, how do I link you to an exact post number?

I've got a minor tweak to the double-barrelled tally solution. I think it's running consistently quicker in elapsed time, but sometimes my laptop has the older version coming out...

Hey Guru: I borrowed Flo's code to create the tally table instead of doing it the way Jeff taught me, because I wanted to keep an apples-to-apples comparison...

You're an evil man, Jeff Moden.

Okay... I just have to throw this in..

I just read last night that you can perform updates against inline table valued functions.. They are handled like...

No problem. Here's what I've got. My understanding is that it can't be used for commercial purposes.

Jeff: Who did your awesomely animated NO RBAR logo?

Hey Guru:

I like your Lobo-esque avatar too. I can't remember the exact site where I got this one (which is currently an angled perspective in blue...