Hi there,

I have been trying to build this stored procedure but no luck so far. this is what I'm trying to accomplish;

a stored procedure to pull sales from let's say sales from a specific date 10/10/06 and I want the same stored procedure to pull sales data from one year before 10/10/05 from the first parameter.

so I want the stored procedure to pull data from one date and one year's date before.

Thanks for your help.

Midway.

Post your attempt at the stored procedure your trying for.

use this

select OrderDate, dateadd(yy,-1,OrderDate) from Orders

select * from orders
where orderdate between 'date you want to start' and datediff(yy,-1,date from you want to minus 1 year)

all the best