Home Forums SQL Server 2005 SQL Server Newbies SQL Pivot by Week Of date when week of dates are not Defined in the Query RE: SQL Pivot by Week Of date when week of dates are not Defined in the Query

  • September 20, 2013 at 1:15 am

    #1651785

    CREATE TABLE [dbo].[gotilla](

    [ID] [int] NULL,

    [Category] [varchar](50) NULL,

    [Weekof] [varchar](50) NULL,

    [Total_hur] [int] NULL

    )

    select category ,id,Sum(case when weekof='7/2/2012'then total_hur end)as '7/2/2012',

    SUM(case when weekof='7/16/2012'then total_hur end)as '7/16/2012',

    SUM(case when weekof='7/9/2012'then total_hur end)as '7/9/2012'

    from gotilla

    group by category,id