Post reply

Query Help

  • March 30, 2012 at 4:09 am

    #254052

    I have a table like this:

    Col1[Varchar(20)]Col2[numeric(28,2)]Col3[Datetime]

    DB112.242012-01-20

    DB135.452012-02-20

    I need this informaiotn in the following way:

    Col12012-01-202012-02-20

    DB112.2435.45

    How can we achieve this ?

  • March 30, 2012 at 4:34 am

    #1466849

    have a look at CROSSTAB or PIVOT

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply