Parameter to Parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Parameter to Parameter

Parameter to Parameter

Rate Topic

Display Mode

Topic Options

Author

Message

Trybbe

Posted Tuesday, July 22, 2008 5:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 169, Visits: 440

Hi! I'm back

How do I pass the value of a parameter to another parameter.

Post #538324

Trybbe

Posted Tuesday, July 22, 2008 6:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 169, Visits: 440

Ok. got that sorted by choosing non-queried for available values and setting the value to '=Parameters!EndPeriod.Value. However that makes my query extremly slow

Please help

Post #538382

vee van gelder

Posted Tuesday, July 22, 2008 6:46 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, April 28, 2013 11:40 PM
Points: 384, Visits: 278

in your datasets say for eg

select * from this where this is in (@parametername)

if you want more help, i think you need to give more details.

Post #538418

Hari.Sharma

Posted Tuesday, July 22, 2008 6:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330, Visits: 455

thatok (7/22/2008)

Ok. got that sorted by choosing non-queried for available values and setting the value to '=Parameters!EndPeriod.Value. However that makes my query extremly slow

Please help

thatok,

Its not clear about your source Table size.

It may be the reason that your filter condition is taking too much time.

If this is the case, you need to optimize your query by proper indexing.

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Post #538423

Trybbe

Posted Tuesday, July 22, 2008 6:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 169, Visits: 440

Here's the scenario:

Dataset1:
Select *
from MyTable
Where Period Between @StartPeriod AND @EndPeriod; --- Works like a charm

Dataset2:
Select *
from MyTable
Where Period = @Period;

@Period should get its values from @EndPeriod.

The idea is: Headcount report showing monthly staff headcount in a table and Year to Date growth in a graph. Dataset1 would populate the graph while dataset2 populates the table

Post #538426

vee van gelder

Posted Tuesday, July 22, 2008 7:06 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, April 28, 2013 11:40 PM
Points: 384, Visits: 278

why can't you just put

Dataset2:
Select *
from MyTable
Where Period = @EndPeriod;

?

Post #538435

Trybbe

Posted Tuesday, July 22, 2008 7:13 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 169, Visits: 440

Thank you very much. It works. And it's fast again

Post #538448

vee van gelder

Posted Tuesday, July 22, 2008 7:16 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, April 28, 2013 11:40 PM
Points: 384, Visits: 278

good to hear!

Post #538449

« Prev Topic | Next Topic »

Permissions