Viewing 15 posts - 22,066 through 22,080 (of 26,490 total)
Here is another way to generate the dates you are generating.
CREATE FUNCTION dbo.DatesInRange(@StartDate datetime, @StopDate datetime)
RETURNS TABLE
AS
return
with
a1 as (select 1 as N union all
...
March 10, 2009 at 9:05 am
please confirm that the purpose of the function is to return a table of dates between a given StartDate and EndDate inclusively, ie if StartDate were 2009-01-01 and EndDate were...
March 10, 2009 at 8:43 am
I would not repost in a SQL Server 2000 forum at this time as people have already started helping you out here. However, I would just be sure that...
March 10, 2009 at 8:30 am
GilaMonster (3/9/2009)
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send...
March 9, 2009 at 3:13 pm
Alvin Ramard (3/9/2009)
Lynn, you left out one benefit of traveling. It also makes it easier to beat some sense into them. Of course, only AFTER you've been paid.😀
True,...
March 9, 2009 at 2:48 pm
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back...
March 9, 2009 at 2:37 pm
Alvin Ramard (3/9/2009)
Lynn Pettis (3/9/2009)
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone...
March 9, 2009 at 2:35 pm
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you...
March 9, 2009 at 2:20 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are...
March 9, 2009 at 2:10 pm
Okay, this topic has been double posted. I suggest any further discusion continue in this thread. To see what else has been suggested, look here.
March 9, 2009 at 2:05 pm
Okay, we have a double post here with answers going in both. I suggest continuing any further discussion on this topic here (meaning the other thread).
March 9, 2009 at 2:03 pm
Brandie Tarvin (3/9/2009)
Depends on the situation. You can't always fix the Group By. Sometimes it screws up your result set if you do.
Believe me, I've tried that. Sometimes fixing the...
March 9, 2009 at 12:27 pm
GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.
That is too funny! ...
March 9, 2009 at 12:08 pm
Can you capture the execution plan, zip it, and post to this thread? there may be more going on than just changing to a hard coded set of values.
Also,...
March 9, 2009 at 12:06 pm
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.
Look at his latest post on that thread. I mean,...
March 9, 2009 at 11:55 am
Viewing 15 posts - 22,066 through 22,080 (of 26,490 total)