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 |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2008-03-11 : 07:12:21
|
| Hello.I have one dataset with a few parameters.Each parameter get its available values from the some dataset.So if I have the main DS whice is:"select name,age,sex from table1 where age = @age and sex = @sex"The available values for the parameters "age" and "sex" are those datasets:"select distinct age from table1" and"select distinct sex from table1".The problem is thet the query on table1 takes a lot of time and in this case I need to run her three times.Is there a way to initialize the parameters values in one query excution and save some time?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 07:23:19
|
| Initialize? You mean provide default values for them? or for the population? |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-03-11 : 08:50:52
|
| Hello.I mean providing the parameters the available values.thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 09:08:46
|
| Dont thing you can do anything other than giving direct values in non queried mode. |
|
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-03-11 : 13:12:55
|
| I was afraid of that.It really annoying since its taking me a lot of time to give each parameter his list of available values from the dataset and if I have 5 parameters the report wait until all of them will get there values before it load and it all from the same dataset.Thanks any way :) |
|
|
|
|
|
|
parameters value from one dataset