-
Condition joins based on parameters
I'm using SQL Server 2005 Reporting Services. Apologies if this is in the wrong area.
I'm not sure if it's possible but what I want to do is join table dimFactor to factMedia using different fields dependent on the partameter value.
i.e
from FactMedia fm...
if parameter value = 1
INNER JOIN dimFactor df ON df.FactorID = fm.AgeGroup_ID
if parameter value = 2
INNER JOIN dimFactor df ON df.FactorID = fm.Gender_ID
and so on..
Can this be done and if so, how??
I've tried using CASE statements but it's not having any of it.
Help please!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|