Viewing 15 posts - 47,911 through 47,925 (of 59,064 total)
GilaMonster (10/3/2008)
This one's pretty good. Read the comments on the blog post too, as the function needs a table creating.
Teach someone to fish... please see the following URL for how...
October 4, 2008 at 6:12 pm
Grant Fritchey (10/2/2008)
First, try using BETWEEN instead of >= <= on the date fields.
Ummm... why, Grant? They BOTH appear in the >= <= form after the optimizer evaluates them....
October 4, 2008 at 5:51 pm
Rich96 (10/4/2008)
That did it. Thanks Matt.. 5 stars.I finally found a table of characters.. if anyone is interested.
Cool. Thanks for the feedback.
If you ever need to make one...
October 4, 2008 at 5:33 pm
Although it has worked very well in the present and in the past, I wonder if folks understand that Updating an alias is actually an undocumented feature? 😉
October 4, 2008 at 5:07 pm
sql-oholic (10/2/2008)
I am trying to get # of rows for a table.
I used sp_spaceused, through which I get a number which is different compared to number I get when I...
October 4, 2008 at 4:38 pm
Paul, is that correct? The date format is dd/mm/yyyy?
October 4, 2008 at 4:33 pm
Rich96 (10/2/2008)
October 4, 2008 at 4:15 pm
Sure... but let me ask a question... what does "Duration" contain? It can't be the number of months because there's actually only 3 months between the two dates given.
October 4, 2008 at 4:07 pm
zypsy (10/4/2008)
October 4, 2008 at 4:04 pm
andrew gothard (10/4/2008)
"Are you good with cursors" "Brilliant - I never use them". This is often misunderstood
Heh... I often ask that question to find out what the...
October 4, 2008 at 3:57 pm
Heh... define "performance". Are you talking speed of code, speed of developing code, speed of testing code, computational ROI, ease of maintenance, ease of use, ease of interface, cost...
October 4, 2008 at 3:46 pm
Anirban Paul (10/4/2008)
October 4, 2008 at 3:16 pm
Heh... 2/30/... that's a good one.
Like Dugi said, it would be helpful if we had more information. If you want a really good answer, read and heed the article...
October 4, 2008 at 1:28 pm
Want a better answer faster? Take a look at the link in my signature below and also post the query you already have. 😉
October 4, 2008 at 1:25 pm
Viewing 15 posts - 47,911 through 47,925 (of 59,064 total)