You will have to use cascading parameters, thus, yes, more than one parameter. SSRS is not the best reporting tool for these types of things. It does have...

Good Point!

Ok, maybe off topic a little, and I am NO WHERE NEAR perfect either. But it seems to me that most of the QofD can be interrepted in different...

For GilaMonster:

"

SSC-Dedicated

Group: General Forum Members

Last Login: Today @ 12:34:41 PM

Points: 38,687, Visits: 31,083

"

Hmm, when I go to a fourm entry by Jeff Moden I get:

"

SSC-Dedicated

Group: General Forum Members

Last Login: Today @ 3:27:31 AM

Points: 33,532, Visits: 27,536

"

Hmmm, vivekjamshedpur has a good piont: http://www.sqlservercentral.com/TotalScores ,

http://www.sqlservercentral.com/Forums/Topic935523-83-1.aspx both links show different point system!

I think I got lucky really, the question should have said something like what is the user with points between 30k and 40k. becasue there are a few correct answers...

Hey, got this one right, I just looked at Jeff Moden's points - 33k and says Dedicated......

And the name of the stored proc is in brackets like this: [storedProcName] for the datase.

Keon is right, really have no idea what you are trying to do without more information. I use parameters and stored procs in datasets many times. One thing...

Dang It! Did it again. I did NOT get my coffee before answering the question. Thus, missed it again. Good question.

Erueka, thanks Hugo Kornelis. I had not even thought of Collation. Makes sense now. Learning something new everyday is a good thing. Ok, I learned my...

Thanks, mleehayes. It must be me, I get same error on 2005 as well as 2008. hmmm....

Ah, posted my answer before I read roe3p post. Same idea I was trying to make.

Good question. I missed this because on SQL 2008 R2 I get error with 'c.ID could not be bound'. So I picked SQL would return an error. Obviously I...