I have a stored proc that runs every night. My manager says data is sometimes different even tho for some rows it has to be the same.
So i put a debug step and been logging the data every day. I want to see what rows are different from today to next day (i have the dates)
I've logged data for 17 days. From Sept 30 to Oct 17th. This is what I do to see what's different but I get no rows back. I keep plugging in
da X and day X+1 is this a correct SQL?
select * from dbo.OrderAnalysisDebug
where updatedate = '2011-10-06 06:00:20.010'
and not exists (select * from dbo.OrderAnalysisDebug where updatedate = '2011-10-07 06:00:10.020')