well, I have a trigger that reads the latest inserted data and insert them into another table. I've wrote the trigger, then it inserted all data from the first table, where I need only the daily data inserted. and so, I've added a condition where date = today date.
and I am checking that now.
If you want to find out today's data, use
where datecol>=dateadd(day,datediff(day,0,getdate()),0) and
Failing to plan is Planning to fail