Dynamically delete the data based on date column

• maheendra.puttareddy

  SSC Enthusiast

  Points: 119

  More actions

  May 19, 2015 at 12:36 am

  #300788

  DELETE FROM Report_temp2

  WHERE MSSalesID in

  ( Select Report_temp.MSSalesID FROM Report_temp)

  DELETE FROM Report_temp

  WHEREMSDate < '2015-07-01'

  Actually the year stating form july.Q1 is july,aug,sep.Q2 is oct nov,dec.Q3 is jan,feb,mar.Q4 is april, may,june.So what I need help is dynamically I want to delete the data every year prior to current year.

• imex

  Ten Centuries

  Points: 1234

  More actions

  May 19, 2015 at 11:21 am

  #1799110

  Try:

  where

  MSDate < DATEADD(MONTH,

  6,

  DATEADD(YEAR,

  DATEDIFF(YEAR, 0, @data) - 1 + MONTH(@DATA) / 7,

  0))

  Hope this helps.

  https://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos

• maheendra.puttareddy

  SSC Enthusiast

  Points: 119

  More actions

  May 20, 2015 at 1:52 am

  #1799257

  I am not getting what is the @data please clarify me

• Dohsan

  SSCrazy

  Points: 2972

  More actions

  May 20, 2015 at 2:23 am

  #1799262

  Try using GETDATE() instead of @data in Imex's example, it should get you to where you want

• maheendra.puttareddy

  SSC Enthusiast

  Points: 119

  More actions

  May 20, 2015 at 4:52 am

  #1799281

  Thank you very much this is really helpful to me