immaduddinahmed (6/7/2013)
i am having this errorMsg 257, Level 16, State 3, Procedure query, Line 21
Implicit conversion from data type datetime to float is not allowed. Use the CONVERT function to run this query.
this is the line and red one is the column that i replace from 540
CAST (ABS( t4.LTime - DATEDIFF (MINUTE, t.[Timein], t.[Timeout] ) ) % 60 as varchar ) + ' min' as excesshort, -- Minutes
this column t4.LTime datatype is datetime
please help me out
You are trying to use the ABS function with datetime data. It can only take numeric data. http://msdn.microsoft.com/en-us/library/ms189800.aspx
What are you trying to achieve?