SUM total time in SQL Server [duplicate]

by

if the time in hh/mm/ss then :: 

SELECT studentid,studentname,
         DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', mytime)), '00:00:00.000') as time
    FROM
         worknote

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. How to create a specific SQL Server stored procedure? [closed]
  3. SQL Server dynamic PIVOT query?
  4. SQL Server – Best way to get identity of inserted row?
  5. Should I use != or for not equal in T-SQL?
  6. How to update two tables in one statement in SQL Server 2005?
  7. SQL Server Process Queue Race Condition
  8. Create a date from day month and year with T-SQL
  9. How should I pass a table name into a stored proc?
  10. Is the NOLOCK (Sql Server hint) bad practice?
  11. Creating an index on a table variable
  12. SQL – Subtracting a depleting value from rows
  13. OR is not supported with CASE Statement in SQL Server
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. How to set variable from a SQL query?
  16. SELECT FOR UPDATE with SQL Server
  17. Compare DATETIME and DATE ignoring time portion
  18. T-SQL: Selecting Column Based on MAX(Other Column)
  19. How to group by month from Date field using sql
  20. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  21. SQL dot notation
  22. Split function in SQL Server 2008
  23. T-SQL How to create tables dynamically in stored procedures?
  24. What is the equivalent of ‘describe table’ in SQL Server?
  25. Curly braces in T-SQL
  26. OPENXML with xmlns:dt
  27. Find min and max for subsets of consecutive rows – gaps and islands
  28. How can I group by date time column without taking time into consideration
  29. T-SQL: checking for email format
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment