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 |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2010-10-27 : 01:10:10
|
| Deall All,I am having following query and result, in that i want reuslt in column, means in result Version,Rate_Deck_ID,Traffic_Type_ID,Traffic_Name,Rate_Deck_Template_ID all are common.Now i want according to Call_type_ID,Call_type_name both rows in one row. e.g. Version Rate_Deck_ID Traffic_Type_ID Traffic_Name Default_Tollfree_Rate Email_ID Call_type_ID Default_Rate Call_type_name Margin Markup Overhead Rate_Deck_Template_ID International_Call_type_ID International_Default_Rate Internation_Call_type_name International_Margin International_Markup International_OverheadMeans in this sequense can we show that.Can anybody please tell me how to do this?QueryDT.Email_ID,RDF.Call_type_ID,ISNULL(RDF.Default_Rate,0) As Default_Rate,CT.Name As Rate_Name,ISNULL(RDF.Margin,0) As Margin,ISNULL(RDF.Markup,0) As Markup,ISNULL(RDF.Overhead,'') As Overhead,DT.Rate_Deck_Template_IDFROM tb_lcr_rate_deck_detail DTLEFT OUTER JOIN tb_lcr_rate_deck RD ON RD.ID = DT.Rate_Deck_IDLEFT OUTER JOIN tb_lcr_traffic_type RDT ON RDT.ID = RD.Traffic_Type_IDLEFT OUTER JOIN tb_lcr_rate_deck_financial RDF ON RDF.Rate_Deck_Details_ID = DT.IDLEFT OUTER JOIN tb_lcr_call_type CT ON CT.ID = RDF.Call_type_IDINNER JOIN tb_lcr_rate_deck_template TM ON TM.ID = DT.Rate_Deck_Template_IDWHERE RD.Customer_ID = '1917D5FF-0C71-4095-8690-0BA43E0390E0' and RD.ID= '295CCE1F-8313-4263-8BAF-DE0E1027D633'and DT.VERSION = '1'ResultVersion Rate_Deck_ID Traffic_Type_ID 1 295CCE1F-8313-4263-8BAF-DE0E1027D633 DC1 295CCE1F-8313-4263-8BAF-DE0E1027D633 INTraffic_Name Default_Tollfree_Rate Email_IDDomestic Certified 0 nilambari.aphale@gmail.comInternational 0 nilambari.aphale@gmail.comCall_type_ID Default_Rate Call_type_nameAF284053-BFCB-41C2-8DE9-96D06F1B5662 0.987 Intrastate4A70917F-1E70-4A4D-9CBA-DF7FF94369AC 0.987 InternationalMargin Markup Overhead Rate_Deck_Template_ID0.9 0 1.4 5BB695A9-C58C-4B3C-BC66-2A3B68BDE0110.8 0 1.6 5BB695A9-C58C-4B3C-BC66-2A3B68BDE011 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Combine two rows in one row.