Post reply

a select question

  • May 2, 2007 at 1:11 pm

    #173888

    there is a table name "price" like this

    priceid,itemcode,itemname,price,priceno

    1,01,melon,10,1

    2,01,melon,15,2

     

    i want to a select query that

    itemcode,itemname,price1,price2

    01,melon,10,15

     

     

  • May 2, 2007 at 1:34 pm

    #703911

    Read up on the PIVOT keyword in BOL.

    🙂

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • May 2, 2007 at 3:14 pm

    #703944

    Thanks a lot

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

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