Stored Procedure Help.
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.