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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 parameter filters with specific items?

Author  Topic 

jimtimber
Yak Posting Veteran

60 Posts

Posted - 2014-09-03 : 06:00:19
Hi guys,

I want a parameter filter to only include certain values from a field. I've never done this before as I usually just "SELECT DISTINCT" in the parameter SQL. Please see the attached pic as I use a 3rd party system to set up my queries on. The pic shows what I usually do but I need it to show in the multiselect box "Online", "telephone call" and "email". How would I write this in the parameter SQL please?

Thanks,

Jim



Jim

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2014-09-05 : 06:59:23
The attachment does not show.

djj
Go to Top of Page
   

- Advertisement -