Posted by laurenq uantrell on 11/29/05 06:25

Oops,
I meant:

SELECT @TodayDate = GETDATE()
SELECT @StartDate = DATEADD(DAY,@StartDaysDiff,@TodayDate)
SELECT @EndDate = DATEADD(DAY,@EndDaysDiff,@TodayDate)

• Next in forum: Re: STORED PROCEDURE - passing table name as a parameter
• Prev in forum: Re: Format() Function in MS SQL
• Thread view: Re: Passing DateDiff rather than Actual Dates as Parameters

[Reply to this message]