Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2010-08-25 : 04:08:03
|
| select t1.*,t2.Product_Name from(select mobid,max(case when seq=1 then merchant else null end) as min_merchant,max(case when seq=1 then price else null end) as min_price,max(case when bseq=1 then merchant else null end) as max_merchant,max(case when bseq=1 then price else null end) as max_pricefrom(select row_number() over (partition by mobid order by price) as seq,row_number() over (partition by mobid order by price desc) as bseq,mobid, merchant,pricefrom tbl_merchant)twhere (seq=1 or bseq=1) and mobid in(select MOBID from tbl_product where Client_Name='wilson')group by mobid) as t1 INNER JOIN tbl_product as t2 on t2.mobid=t1.mobidIn the above query i need to add my_Price field wheremy_price is where my name matches for that product |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-25 : 09:22:08
|
| why are you opening so many threads for same question?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
add a field to table