Viewing 15 posts - 49,246 through 49,260 (of 59,065 total)
Aw crud... I've lost my mind... the method I was talking about doesn't have a thing to do with Float conversions... here's an (very) old set of tests I did....
July 10, 2008 at 8:28 pm
GilaMonster (7/10/2008)
Jeff Moden (7/9/2008)
Nicely done, Gail... It shows that the Convert method takes about 4 times longer than the DateAdd/DateDiff method...
If I hadn't done a test, you probably...
July 10, 2008 at 8:00 pm
AndyD (7/10/2008)
Heh... no wonder you're an MVP.
I think the saying goes, it takes one to know one....
Thanks Andy...
July 10, 2008 at 7:58 pm
MentalWhiteNoise (7/10/2008)
I am personally trying to get some practice with a tally table, so here is what I came up with:
Nicely done... if I may suggest, let's simplify the code...
July 10, 2008 at 7:54 pm
Jeff Moden (7/9/2008)
Will you never have anything with more than one space or punctuation? For example, will you ever have something like "new york, ny"?
I'm still waiting for someone...
July 10, 2008 at 7:30 pm
Date and Time!! - They're finally separate so you can query as salesdate > '2008/07/09' instead of salesdate > '2008/07/09 00:00:00'.
You can do that in all versions of SQL...
July 10, 2008 at 7:15 pm
Ummm... correct me if I'm wrong, please... the code still presupposes that you manually maintain the sort order...
July 10, 2008 at 7:07 pm
Leo Mepham (7/10/2008)
July 10, 2008 at 6:50 pm
That constitutes a "Triangular Join" in a correlated subquery... please read the following as to why those can be so very bad...
July 10, 2008 at 6:44 pm
gan (7/9/2008)
then you meant ident_current('table name') can be used as scope_identity ?
Absolutely not...
July 10, 2008 at 6:24 pm
Aw rats... the fly in the ointment is that the ID's must already be in the correct hierarchical order in order to display in the correct order... Gotta add...
July 9, 2008 at 9:17 pm
The neat thing about that code is that it allows for multiple top levels if you need them... thanks again.
July 9, 2008 at 9:10 pm
terry.jago (7/9/2008)
July 9, 2008 at 9:03 pm
Viewing 15 posts - 49,246 through 49,260 (of 59,065 total)