SQLTeam.com | Weblogs | Forums

Filter by day and month only for each year

sql2008r2

#1

Is their any way to get data only by day and month for each year. coz their is one stored procedure which has two parameters. start date and invoicedate. it returns the data proir to three years back every time.

whenever i give invoicedate it should check that date only by day and month for each year.


#2

Would you please post here:

  1. CREATE TABLE definitions for the tables involved
  2. INSERT INTO statements for some sample data (10 rows or so)
    3, CREATE PROCEDURE definition for the stored procedure you are calling (btw, I assume you mean "there" not "their")
  3. The results you are getting
  4. the results you want to see.

#3

got it. Thanks