Home Forums SQL Server 2008 T-SQL (SS2K8) Need help in putting the correct WHERE Clause RE: Need help in putting the correct WHERE Clause
Mac1986
SSCertifiable
Points: 6216
More actions
January 6, 2013 at 4:46 am
#1574116
I did something similar.. thanks a lotwhere cast((datediff (ss,BatchStartTime,BatchEndTime)) as decimal(8,0))/60.0 > 120
where cast((datediff (ss,BatchStartTime,BatchEndTime)) as decimal(8,0))/60.0 > 120