none
Pivot table insert

    Question

  • I have a temp table has date time information like following

    MyDate

    05/01/2013

    05/03/2013

    and I would like to have my data convert to the table like following

    Date1,             Date2

    05/01/2013    05/03/2013

    Are there any pivot table to do this task?

    Your help and information is great appreciated,

    Regards,

    Souris,

    Wednesday, May 22, 2013 1:12 PM

Answers

  • Hello,

    Please , could you provide more information about your problem ?

    - Is it for a SQL Server table ? If yeas, could you provide the full version ( 2008 , 2008 R2 , 2012 + last installed service pack ) and the edition ( Express , Web , Standard , ... ) ?

    - the exact and full definition of your table ( including the columns of your table )

    - what is the collation of your database/ SQL Server instance

    We are waiting for your feedback to try to help you more efficiently.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    • Marked as answer by sourises Thursday, May 23, 2013 11:52 AM
    Thursday, May 23, 2013 8:14 AM

All replies

  • Hello,

    Please , could you provide more information about your problem ?

    - Is it for a SQL Server table ? If yeas, could you provide the full version ( 2008 , 2008 R2 , 2012 + last installed service pack ) and the edition ( Express , Web , Standard , ... ) ?

    - the exact and full definition of your table ( including the columns of your table )

    - what is the collation of your database/ SQL Server instance

    We are waiting for your feedback to try to help you more efficiently.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    • Marked as answer by sourises Thursday, May 23, 2013 11:52 AM
    Thursday, May 23, 2013 8:14 AM
  • Thanks for helping,

    I use SQL 2008.

    I do some research and find solution for this,

    Thanks again,

    Regards,

    Souris,

    Thursday, May 23, 2013 11:53 AM