Viewing 15 posts - 4,726 through 4,740 (of 7,636 total)
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.
November 27, 2008 at 10:14 pm
Actually, Plan Guides might be able to do this. Unfortunately, I missed that session at PASS.
November 27, 2008 at 8:26 pm
I am not sure, but full-text indexing might be what you are looking for.
November 27, 2008 at 8:15 pm
GilaMonster (11/25/2008)
Chat with the speakers. None of them bite.
Well..., there's Grant. But I don't think that he actually broke the skin.
😀
November 27, 2008 at 7:55 pm
Great tips, Nicholas! This was my first year too, but I have been to many conferences and was pretty savvy about the tricks.
I will say that a good Laptop/Backpack...
November 27, 2008 at 7:54 pm
Something like this:
DIM s as string
s = ""
If Commodity1=True then s = s + "Commodity1,"
If Commodity2=True then s = s + "Commodity2,"
...
If Commodity20=True then s = s + "Commodity20,"
s =...
November 27, 2008 at 6:45 pm
Tony:
I see some UDF's in the Matrix workbench: They're not going to work on SQL Server 7.0. 🙂
November 27, 2008 at 6:30 pm
Chris:
I just notice that you are putting "and" after your Hundreds, like this:
nine hundred and seventy seven thousand, six hundred and ninety two dollar(s)
Technically, this is incorrect,...
November 27, 2008 at 5:36 pm
Jeff:
Your function is called "NumberToWords" but you are calling "MoneyToWords", is this just a typo or am I missing something?
November 27, 2008 at 5:07 pm
Jeff Moden (11/27/2008)
November 27, 2008 at 4:39 pm
drjdewhurst (11/27/2008)
In the end I simply ordered the table by the combined differences between the target latitude and longitude and the latitude and longitudes in the...
November 27, 2008 at 4:30 pm
Try this:
Select * From INFORMATION_SCHEMA.ROUTINE_COLUMNS
November 27, 2008 at 1:28 pm
Chris Morris (11/27/2008)
RBarryYoung (11/27/2008)
Man, you write nice code, Chris. I always enjoy reading it.:blush: erm, :blush: so long as it looks nice! Sometimes it works too...
I mean the...
November 27, 2008 at 1:21 pm
Just a question: It looks like SWITCH will only work here for IDENTITY changes. Are there any other column changes that it will work for?
November 27, 2008 at 12:22 pm
Viewing 15 posts - 4,726 through 4,740 (of 7,636 total)