Report Parameter - SQL Server Forums

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 2005 Forums

Analysis Server and Reporting Services (2005)

Report Parameter

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2007-09-25 : 02:20:10

Hi all

I'm trying to figure how do I pass from Report Parameter for @MemberName parameter (NON-QUERIED) such as: 'Domain Admins','Local Install','maadmin','Helpdesk Systech','Administrator'

My query for dataset is:

SELECT id,
ComputerCN,
GroupName,
MemberName,
ScanDate
FROM tbl_GROUPMEMBERS WITH (NOLOCK)
WHERE ComputerCN LIKE '%' + @ComputerCN + '%'
AND MemberName NOT IN (@MemberName)
ORDER BY ComputerCN ASC

How do I pass this value into IN? It seems that it passed the whole string instead.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-25 : 12:15:42

http://www.sqlteam.com/article/using-a-csv-with-an-in-sub-select

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources