.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SQL Help

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
 

Hi all,

I have the following, where I have the same query but the value in Plan_key in the where clause between the queries is different.

SELECT Level, Ratio, Calc FROM

fact_level

WHERE
plan_Key in (3011,3012)


Level Ratio Calc
1     12    22
2     12    22
3     13    43
4     32    42


SELECT Level, Ratio, Calc FROM

fact_level

WHERE
plan_Key in (222,3201)

Level Ratio Calc
11     12    22
21     12    22
31     13    43
41     32    42


I would like to acheive the results of both side by side...how can i do this??

LevelA RatioB CalcB LevelB RatioB CalcB
1         12       22      11       12     22
2         12       22      21       12     22
3   &nb


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend