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 |
|
rockstar283
Yak Posting Veteran
96 Posts |
 Posted - 2011-09-15 : 20:32:40
|
| I am building a report with parameters and I receiving 'level,fab,tier,wave' from the report..so I need to form a dynamic query as follows:SELECT A.X FROM(SELECT X FROM DIM WHERE CHAR='level') AS AJOIN(SELECT X FROM DIM WHERE CHAR='fab') AS BON A.X=B.X JOIN(SELECT X FROM DIM WHERE CHAR='tier') AS CON B.X=C.XJOIN(SELECT X FROM DIM WHERECHAR='wave' ) AS DON C.X=D.XThe query will increase depending on the no. of sub-parameters I get from the report..can somebody please help me in forming this query..thanks in advance |
|
|
rockstar283
Yak Posting Veteran
96 Posts |
Posted - 2011-09-15 : 22:37:31
|
| I have reached till here..SELECT C.X FROM(SELECT X FROM DIM WHERE CHAR='level') AS A1 JOIN(SELECT X FROM DIM WHERE CHAR= 'fab') AS A84 JOIN(SELECT X FROM DIM WHERE CHAR= 'die') AS A147 JOIN(SELECT X FROM DIM WHERE CHAR= 'fert') AS A211 JOIN(SELECT X FROM DIM WHERE CHAR= 'pert') AS CCan somebody pls help to insert the JOIN condition in this string..The end result should beSELECT C.X FROM(SELECT X FROM DIM WHERE CHAR='level') AS A1 JOIN(SELECT X FROM DIM WHERE CHAR= 'fab') AS A84 ON A1.X=A84.XJOIN(SELECT X FROM DIM WHERE CHAR= 'die') AS A147 ON A84.X=A147.XJOIN(SELECT X FROM DIM WHERE CHAR= 'fert') AS A211 ON A147.X=A211.XJOIN(SELECT X FROM DIM WHERE CHAR= 'pert') AS CON A211.X=C.X |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-16 : 12:21:20
|
| can you tell purpose of all these joins? whats end result you're looking at?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Help with Strings