|
NickC
Yak Posting Veteran
United Kingdom
68 Posts |
 Posted - 02/19/2013 : 11:17:02
|
Hi
Im looking to see if I can make a paramater dependenet on another in SQL (AND SSRS)
Basicaly we currently have a look up where people put part of a name in and it takes all of them and searches
"
WHERE
Contact_Name LIKE '%' + @BrokerLookup + '%'
"
so if it was like nic
it would pick out nick, nicholas, nic from the contact name
what I then want is a second paramater that goes okay heres all the contact names liek nic, now in ssrs I want just nick and nicholas and to exclude nic...
how would I do this in SQL? I think SSRS bit is just a case of adding a paramater which is hidden until someone types in something in to first paramater am i right?
Many Thanks
Nic, Nick, NIcholas :) |
|
Cascading Paramater
