Home Forums SQL Server 2012 SQL 2012 - General trying to create a table - unpivot RE: trying to create a table - unpivot

  • October 8, 2013 at 8:45 am

    #1656774

    hi,

    please find the sample requested

    CREATE TABLE clicks (RecordDay datetime, ClickCount INT)

    GO

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-05 13:23:44, 2)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-05 15:45:21, 6)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-05 16:45:21, 1)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-05 17:45:21, 12)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-04 18:45:21, 3)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-10-03 19:45:21, 24)

    INSERT INTO clicks (RecordDay datetime, ClickCount INT)

    VALUES(2013-11-02 20:45:21,3)