DateAdd function in store procedure...

Question

Using SQL Server-2005

Here, I want to generate reports for reminders in Automobiles Industries for post follow-ups.

Reminders will generate in slabs, such as on Invoice Date

1st Reminder will be between 15-30 Days.

2^nd Reminder – 105-120 Days

3^rd Reminder – 195-210 Days

4^th Reminder – 285-300 Days

---STORE PROCEDURE FOR 1ST FREE SERVICE REMINDER

CREATE PROCEDURE spFS1

@FROMDATE DATETIME,

@TODATE DATETIME

AS

BEGIN

select *,

dateadd(day,datediff(day,0,InvDate)+30,0) as FIRST_SERVICE_DUE_TO

from pfs_tbl

where InvDate between

@FROMDATE AND @TODATE

ORDER BY InvNo

END

---STORE PROCEDURE FOR 2ND FREE SERVICE REMINDER

 

CREATE PROCEDURE spFS2

@FROMDATE DATETIME,

@TODATE DATETIME

AS

BEGIN

select *,

dateadd(day,datediff(day,0,InvDate)+120,0) as SECOND_SERVICE_DUE_TO

from pfs_tbl

where InvDate between

@FROMDATE AND @TODATE

ORDER BY InvNo

END

--- how to write query in single Store procedure for using more than one DateAdd function?