asked
Query to exclude 2 days of records based on timestamp
Please help me on this how to exclude two days of data and everyday it should insert todays data for your reference see the below query DELETE A FROM [dbo].[t_account] A JOIN [dbo].[t_DMT_Upload_Account_Log]l ON A.ACCOUNTID=L.ACCOUNTID WHERE datediff(d,getdate(),[DateStamp])<=2
I'm a little confused by your question and code. You said you need to insert today's data, but you gave us a delete statement. Is the idea to always just keep data from the past 2 days? In other words, delete the old data and insert today's data?
Assuming your [DateStamp] field is a date-related data type and the precision of datediff() with getdate() and your date are adequate for your purpose, then the following where clauses should work. To include data older than the past 2 days in the criteria... WHERE DATEDIFF(DAY,[DateStamp],GETDATE()) > 2; To include the past 2 days of data in the criteria... WHERE DATEDIFF(DAY,[DateStamp],GETDATE()) BETWEEN 0 AND 2;
18 People are following this question.
