Hi,Here is an alternative for your solutionSELECT CAST(DATEADD(MILLISECOND,SUM(DATEDIFF(MILLISECOND,0,CAST(TMP.TotalTime as DATETIME))),0) as TIME)FROM( SELECT CAST(timeduration AS TIME) TotalTime FROM mytable) TMP

SQL

SQL-Server

SQL-Server-2005

Adding Time in HH:MM Format - Useful SQL Query

10 Feb 2012 by abdul sami

select aday, code, convert(varchar(5), min(atime), (108))MinTime, convert(varchar(5), max(atime),(108)) MaxTime from testgroup by aday,codeorder by aday asc

SQL

SQL-Server

SQL-Server-2005

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

AJAX vs. Non-AJAX Calls All-in-One Page

31 Aug 2015 by Peter Leow

This is a simple web application to illustrate visually the difference between Ajax and non-Ajax calls that take place all in a single web page.

All the jobs in SQL Server

10 Aug 2011 by seankk

SQL

SQL-Server

SQL-Server-2005

All the jobs in SQL Server

10 Aug 2011 by Wendelius

Or simply:exec msdb..sp_help_jobsp_help_job (Transact-SQL)[^]

SQL

SQL-Server

SQL-Server-2005

Alter table - Add new column and set the position

1 Apr 2010 by otomazeli

Introduction...

SQL

Always close your cursor

13 Oct 2011 by Elina Blank

When cursors are inside transaction, it is sometimes easy to forget to close the cursor

SQL

SQL-Server

Always close your cursor

13 Oct 2011 by Elina Blank

An alternative (simpler way :) ) is:BEGIN TRANDECLARE IdCursor CURSOR FOR SELECT Id FROM MyTable OPEN IdCursor FETCH NEXT FROM IdCursor INTO @CurrentIdWHILE (@@FETCH_STATUS) = 0 BEGIN -- do work IF @@error 0...

SQL

SQL-Server

Always close your cursor

18 Oct 2011 by Kabwla.Phone

You also might want to look into the "LOCAL" keyword.This limits the scope of the cursor to the context in which it is created.DECLARE IdCursor CURSOR LOCAL FOR SELECT Id FROM MyTableThis is beneficial for many reasons.

SQL

SQL-Server

Always close your cursor

18 Oct 2011 by Elina Blank

To see the default value of the cursor scope:select * from sys.databases(if value of "is_local_cursor_default" is 0 then scope id global, otherwise it is local).The scope is GLOBAL by default (for compatibility reasons).To change default scope use following:ALTER DATABASE...

SQL

SQL-Server

Amount to Words

18 Dec 2016 by NightWizzard

Convert amounts to their spoken equivalents

Anonymization of Patients' Data in MySQL

28 Sep 2015 by Member 11313437

How to easily anonymize (or pseudonymize, depending on the depth of performing) patients' proper data in clear text in MySQL

SQL

MySQL

Another reason for getting the error “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” in MS SQL Server 2008

14 Nov 2012 by Sadeque Sharif

Another way to solve the issue of “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

Another Way to Get Identity from SQL Server

26 Aug 2015 by nithyananthams

Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.

Anyone Who Is Querying Ought To Know These

15 Oct 2015 by Shyam S Singh

This is a simple tip to describe how to write an optimized SQL query when we are dealing/working on large amount of data.

SQL

Apply Operator in SQL Server

16 Nov 2015 by sandeepmittal11

Apply Operator in SQL Server

T-SQL

SQL

Apply Operator in SQL Server Simplified

14 Mar 2015 by Gaurav_Chaudhary

This tip is a brief introduction to Apply operator in SQL server

SQL

SQL-Server-2014

SQL-Server-2012

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

10 Sep 2018 by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

Applying Running Total to a Result set

8 May 2012 by Chamila Nishantha

This tip describes how to add a running total column to a result set

Applying Running Total to a Result set

14 May 2012 by Wendelius

This is an alternative for "Applying Running Total to a Result set"

Arbitrary parameters in SSIS for OLE DB

1 Jul 2014 by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

Ask Your Database for that Unique ID

2 Sep 2015 by Peter Leow

Get your database to generate unique running IDs for your application

SQL

MySQL

PHP

ASP.NET 5 - Connect to SQL Azure Database

3 Jan 2016 by JoaoSousa23

Using MVC, Entity Framework, ASP.NET5 Scaffolding, and Azure SQLServer you can create a web application that stores your information on an SQL Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a SQL Azure Database

Assign random value in set to column when updating a table

4 Mar 2014 by Haydn Chapman

A method to update a table column with a random set of specified values

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

7 Dec 2015 by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Auto Backup Of Database in SQL Server 2008 & Above

8 Aug 2015 by Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

Auto Generate a Lot of Columns in Reporting Services (RDL)

15 May 2021 by be05x5

SQL script that will generate XML code that you can copy paste into your RDL file and just do it that way

SQL

XML

RDL

Auto Increment Column Options in Different Databases

4 Jul 2022 by DiponRoy

How to auto increment column options in databases

Auto Increment Column Value is Not Part of Transaction

25 Jun 2018 by connect ashish yadav

Auto increment column value is not part of transaction

SQL

Automatic Missing Indexes Creation Statements

30 Mar 2024 by GabrieleTronchin

Automatic creation of non clustered indexes using system SQL entities

Autosuggest TextBox from database column in Windows Forms

19 Apr 2012 by Deepak_Sharma_

This article will show how to create an auto-suggest TextBox that will suggest data from a SQL Server database column.

Backdoor TFS User Image and Email Manipulation

31 Mar 2017 by ergohack

Do you need to update everyone's TFS picture? Or set the notification email address for that calcitrant employee?

Backup Stored Procedures in SQL Server

13 Sep 2012 by CorvetteGuru

Backup Stored Procedures in SQL Server.

Basic App to Insert the Contents of an XML File into a SQL Table with SQLBulkCopy

16 Nov 2015 by MarcusCole6833

Making XML SQL .NET style!

Basic SQL Auto-Purging for Document Management

25 Jul 2012 by Dan Steuer

This article will help manage automatic database purges according to basic Document Management principles.

Basic Troubleshooting for Microsoft SQL Table Lock

1 Oct 2014 by NaibedyaKar

How to check the query locking the table and to unlock it

Be Very Careful When You Write SQL Trigger

18 Feb 2012 by Mahmud Hasan

Be Very Careful When You Write SQL Trigger

SQL

SQL-Server

Binding jqxGrid to SQL Database using ASP.NET Web Service ( Responsive & Right-to-Left & Farsi )

12 May 2015 by Masoud Ehteshami (Iran)

main source : https://www.jqwidgets.com

Binding of Calendar Controls from Database

8 Mar 2014 by SanSkun

How to bind holiday list and information about those holidays from database

SQL

ASP.NET

Bitwise OR aggregate

28 Mar 2012 by PIEBALDconsult

Performing a bitwise OR aggregate in SQL Server

SQL

SQL-Server

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

Build a Date Function

23 Nov 2012 by Rob Branaghan

Just a function to make populating a datetime variable easier!

T-SQL

SQL

Build a Date Function

26 Nov 2012 by André Kraak

This is an alternative for "Build a Date Function"

T-SQL

SQL

Build Dynamic Order by Clause in LINQ Query in C#

5 Jun 2022 by Ramesh Bevara

An overview of a helper class to build dynamic order by clause in LINQ query in C#

Build Your Own Movie Database with SQL Server

24 Oct 2016 by Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

Busy Production Database Update Without Timeout

9 Jun 2019 by Prasannakumaran Sarasijanayanan

Load data to temporary table, make any additional update if required, create necessary indices, finally DROP live table and RENAME temporary table to production table.

Calculate aggregates for dynamic columns using UNPIVOT

17 Jan 2013 by Wendelius

This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.

Calculate Geo Distance Using SQL Server

8 May 2017 by Nirav Prabtani

How to calculate distance between two geolocations or find out distance within a specific radius by SQL Server

Calculating Average Processing Time in Hours Excluding Weekends

17 Dec 2014 by Mohammed A. Mohiuddin

Calculating Average Processing Time in hours excluding weekends

SQL

Oracle

Calling CL Programs on the IBM i on Power from PHP using DB2 Stored Procedures

21 Dec 2012 by Nathan Stiles

Calling CL programs on the IBM i on Power from PHP using DB2 stored procedures.

SQL

PHP

IBM

CASCADE in SQL Server with Example

29 Oct 2017 by vinothharshad

Use the ON DELETE CASCADE option if you want rows deleted in the child table when corresponding rows are deleted in the parent table.

SQL

SQL-Server

Cascading Dropdown In ReactJS

1 Mar 2020 by Sanwar ranwa

How to create a cascading dropdown using ReactJS and Web API

Javascript

SQL

ReactJS

Case sensitive string comparison in SQL

8 Mar 2010 by Neh.C

select * from table where and column COLLATE SQL_Latin1_General_CP1_CS_AS = 'G%E3%97O%D7'

SQL

Challenges in Data Migration Testing

12 Jan 2016 by AgarwalPriyanka, ErGauravSharma

Challenges faced in data migration testing

Challenges in Migrating ASP.NET Apps to Containers #1 – Multiple Active Result Sets

23 Feb 2024 by Mohammad Elsheimy

One of the major issues encountered when connecting to databases after porting ASP.NET app to Docker Linux containers.

Chat / Conversation Balloon Control with datasource

15 Aug 2015 by IssaharNoam

Simple and customizable Chat Conversation control, with DataTable datasource, inspired by SMS application balloons in OnePlus One Android smartphone.

Check Digit Vertical and Horizontal

6 May 2013 by Hernán Hegykozi

This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.

Check if a number is a power of 2 with Sql Server 2012

19 Jan 2013 by Wendelius

This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.

Check Network V1.0

23 Apr 2014 by mohamedkamaleed

Network check v1.0

Checksum for Database

27 Nov 2012 by Paulo Buchsbaum

A simple way to generate checksum for tables and databases.

Clear a DataRow Item (as opposed to deleting it)

26 Jul 2011 by #realJSOP

One way to effectively zero the columns any DataRow object.

SQL

CLR Stored Procedure in SQL Server

10 Mar 2015 by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

CLR-addon for DATE and Split-String

3 Jan 2013 by Levente Kupás

CLR-addon for T-SQL DATE transformation and Split-String

COALESCE and ISNULL in SQL Server

1 Aug 2014 by Uppuluri Aditya

COALESCE VS ISNULL in SQL Server - Part1

SQL

server

COALESCE in SQL Server

15 Nov 2015 by sandeepmittal11

COALESCE in SQL Server

T-SQL

SQL

Code Generator for SQL Server

8 Jan 2020 by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

Combining Insert/Update to one Procedure

14 Jul 2010 by Mycroft Holmes

Why do developers insist on separate procedures to do these jobs

SQL

Combining Insert/Update to one Procedure

4 Apr 2011 by A.J.Wegierski

For Oracle: -------------------------------------------------------------------------------- -- DESCRIPTION -- Universal save -- PARAMETERS IN -- vTRYB: mode: (I)nsert/(D)elete/(U)pdate -- rc: record -- PROCEDURE zapiszObiekt(vTRYB IN...

SQL

Combining Insert/Update to one Procedure

8 Apr 2011 by thatraja

DescriptionC...

SQL

Combining Insert/Update to one Procedure

3 Jan 2012 by Dnyanesh Wahiley

CREATE PROCEDURE sp_Insert ( @ID int, @Name char(20), @Mode char(20) ) ASif @Mode='Insert in Employee'Begin insert into Employee(Employee_ID,Employee_Name)values(@ID,@Name)Endelse if @Mode='Insert in Student'Begin insert into...

SQL

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

27 Sep 2014 by Ahmad A.A. Ahmad