vahid.arr (3/22/2013)
i want to minus two time(time(7) datattype in sql 2008) datatype and multiple(hour and minute) it to 30.how can i do that?this just work for hour
SELECT datediff(HOUR,[EnterTime],[ExitTime] )*30 from Karmand
Can you post some representative sample data and the expected output from it, please? The spec is baffling.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden