Viewing 15 posts - 2,971 through 2,985 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 23, 2009 at 7:06 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 23, 2009 at 6:54 am
Thanks everyone, I truly hope I can be in the audience for some of your presentations.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 23, 2009 at 6:49 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 8:49 pm
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 8:37 pm
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 8:32 pm
DOH! 😛
I think it's buried in all of Flo's posted code here:
http://www.sqlservercentral.com/Forums/FindPost701763.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 4:26 pm
I think it's posted earlier in the thread, Lynn. If I find it, how do I link you to an exact post number?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 4:16 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 4:02 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 2:41 pm
You're an evil man, Jeff Moden.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 2:25 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 1:08 pm
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?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:59 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:32 pm
Heh... better be BIGINT's unless you split the NPA and NXX into separate columns.
I'm from Mississippi, Jeff. Our phone numbers are only 5 digits long. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:20 pm
Viewing 15 posts - 2,971 through 2,985 (of 4,080 total)