yaman bas
SSC-Addicted
Points: 498
More actions
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
Jason Selburg
SSC-Insane
Points: 24641
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.
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