Viewing 15 posts - 46,936 through 46,950 (of 59,064 total)
peter (11/28/2008)
November 28, 2008 at 8:31 am
jacRoberts,
I have SET NOCOUNT ON in the test code so I can't do the verification. Pardon me for asking stupid questions, but I have to check... Have you verified...
November 28, 2008 at 8:22 am
Joe Celko (11/28/2008)
You build a look-up table once (and if you did a proper calendar table, you also benefit from other uses). ...
November 28, 2008 at 8:16 am
I'm not sure what's going on... I ran the code you modified and here's what I got...
===== Set based method with Date table =====
SQL Server Execution Times:
CPU...
November 28, 2008 at 8:06 am
That's about what I would expect from an almost real set of random numbers.
November 28, 2008 at 7:54 am
The problem is that the boogers are risking our money. :crazy:
November 28, 2008 at 7:47 am
Chris Morris (11/28/2008)
rbarryyoung (11/27/2008)
Well I did test them on my laptop. Chris's ran in 13 & 15 seconds, while Jeff's ran in 5.1 and 5.2 seconds.
Testing in my reporting...
November 28, 2008 at 7:44 am
... and here's some things to watch out for...
[font="Arial Black"]Performance Tuning: Concatenation Functions and Some Tuning Myths[/font][/url]
November 27, 2008 at 10:29 pm
Heh... looks like homework questions answered without the OP even trying. 😉
November 27, 2008 at 10:27 pm
Heh... you know I'd show up with the idea that it "can all be done in T-SQL". Now, if we can just get Microsoft to stop deprecating stuff! ...
November 27, 2008 at 10:15 pm
Now that's an awesome idea! I wonder how many volumes you could pack onto a single sided DVD?
November 27, 2008 at 9:45 pm
I've never used MDX queries... that's why I pointed out a traditional cross-tab.
November 27, 2008 at 9:43 pm
Hugo Kornelis (11/27/2008)
Jeff Moden (11/27/2008)
Hugo Kornelis (11/27/2008)
November 27, 2008 at 9:32 pm
Lynn Pettis (11/27/2008)
Okay, can't wait to see Jeff's response. I was using a technique I picked up from him for completing running totals.
Hugo is putting out a lot of...
November 27, 2008 at 9:24 pm
rbarryyoung (11/27/2008)
Jeff:Your function is called "NumberToWords" but you are calling "MoneyToWords", is this just a typo or am I missing something?
Heh... guilty as charged. The Phat-Phinger-Phairy made...
November 27, 2008 at 8:52 pm
Viewing 15 posts - 46,936 through 46,950 (of 59,064 total)