Category Archives: SQL SERVER

How to count every 15 Mins duration group by employees(http://forums.asp.net/t/1808316.aspx/1?How+to+count+every+15+Mins+duration+group+by+employees)

I have seen such type of scenario. so i am providing the easiest way to handle it. Table format:- EmpID Name TransactionDate 101 Abdul 2012-05-2012 08:40:30 0000 101 Abdul 2012-05-2012 09:40:30 0000 101 Abdul 2012-05-2012 12:20:30 0000 102 Raju 2012-05-2012 … Continue reading

Rate this:

Posted in SQL SERVER | Leave a comment