Ramon Quintana

Ramon Quintana

  • NA
  • 404
  • 65.1k

I need to remove some records

Oct 26 2018 8:58 AM
I Could remove records from today and yestarday from a table that has a DATE Field using this sentence:
 
DELETE FROM yourTable WHERE DATEDIFF(day,getdate(),thatColumn) < -1
 
But now I need to remove some records from a table VFS_INTRESS than doesn´t has a DATE field,
for example this: 
 
 
 
I need to left only records from today and yesterday, how can do that?
 
Thanks... 
 
 
 

Answers (6)