SQL Time column conversion sum

Look at the table structure first

 Use [Testmydb]GO/** * * * object:table [dbo].    [Product] Script DATE:2015/9/25 16:09:39 * * * * **/SETAnsi_nulls onGOSETQuoted_identifier onGOSETAnsi_paddingOFFGOCREATE TABLE [dbo].[Product](    [ProductId] [VARCHAR]( $) not NULL,    [ProductName] [VARCHAR]( -)NULL,    [CreateDate] [DATETIME] NULL,    [ Price] [DECIMAL]( -,2)NULL, CONSTRAINT [pk_product] PRIMARY KEY CLUSTERED (    [ProductId] ASC) with(Pad_index= OFF, Statistics_norecompute= OFF, Ignore_dup_key= OFF, Allow_row_locks=  on, Allow_page_locks=  on) on [PRIMARY])  on [PRIMARY]GOSETAnsi_paddingOFFGO

Insert statement

--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Eggs ', GETDATE (), 0.5)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Pork ', GETDATE (), 25.8)--INSERT into dbo. Product VALUES (NEWID (), ' Beef ', GETDATE (), 60.8)--INSERT into dbo. Product VALUES (NEWID (), ' Beef ', GETDATE (), 60.8)--INSERT into dbo. Product VALUES (NEWID (), ' Beef ', GETDATE (), 60.8)--INSERT into dbo. Product VALUES (NEWID (), ' Beef ', GETDATE (), 60.1)

The sum of time and row conversions

SELECTProductName,SUM([1]+[2]+[3]+[4]+[5]+[6]+[ -]) asSummary,[1] ,        [2] ,        [3] ,        [4],        [5],        [6],        [ -]         from(SELECT  --' The price sum of the day ' as Cost_sorted_by_production_days,ProductName,ISNULL([1],0) as [1],        ISNULL([2],0) as [2],        ISNULL([3],0) as [3],        ISNULL([4],0) as [4],        ISNULL([5],0) as [5],        ISNULL([6],0) as [6],        ISNULL([ -],0) as [ -] from(SELECT     Day(createdate) Createdate,productname,SUM(price) price fromDbo. ProductGROUP  byProductName, Day(createdate)) asSourceTable PIVOT (SUM(Price) forCreateDateinch([1],[2],[3],[4],[5],[6],[ -]) ) asPivotTable) asAGROUP  byA.productname,a.[1]A.[2]A.[3]A.[4]A.[5]A.[6]A.[ -]

SQL Time column conversion sum