April 22, 2006 at 3:44 am
Despite my last post.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=274064
I got a slight change in my last post situation as follows:
Tab1
Col_Item varchar(20),
Col_Shop varchar(20),
Col_Rate real
Many shops sales several items at different rate.
I wish to have 3 most min rate shop names with rates against every item.
Current Statues
Col_Item || Col_Shop || Col_Rate
Item1 || Shop1 || 1.2
Item1 || Shop2 || 2.0
Item1 || Shop3 || 3.0
Item1 || Shop4 || 3.2
Item2 || Shop1 || 3.0
Item2 || Shop2 || 3.3
Item2 || Shop3 || 2.5
Item2 || Shop4 || 2.9
Required Outcome (In 7 Columns)
Col_Item || MinShop1 || MinRate1 || MinShop2 || MinRate2 || MinShop3 || MinRate3
Item1 || Shop1 || 1.2 || Shop2 || 2.0 || Shop3 || 3.0
Item2 || Shop3 || 2.5 || Shop4 || 2.9 || Shop1 || 3.0
Please advise how to get the required outcome.
Wishes
Jawad
April 25, 2006 at 8:00 am
This was removed by the editor as SPAM
April 25, 2006 at 8:32 am
Post the update in the first post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=274064
...please don't create a new thread in this situation.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply