<div>
The only way to pull that off is with dynamic SQL<br />
<br />

<pre><code id="code-20-40843730-1">Declare @AssetList varchar(1000) = '1, 2, 3'

Declare @sql nvarchar(1000) 
SELECT @sql = 'Select * From Table Where AssetType  IN (' +  @AssetList + ') '

exec sp_executesql @sql</code></pre>
</div>


The only way to pull that off is with dynamic SQL



Declare @AssetList varchar(1000) = '1, 2, 3'

Declare @sql nvarchar(1000) 
SELECT @sql = 'Select * From Table Where AssetType  IN (' +  @AssetList + ') '

exec sp_executesql @sql

<div>
Do you know if this will work in a SSRS report?
</div>


Do you know if this will work in a SSRS report?

<div>
Don't know about T-SQL within an SSRS, but it will work in a Stored Procedure. &nbsp;<br />
Tell me how 1, 2, 3 is determined, as there are other ways to pull off multiple-value parameters in SSRS.
</div>


Don't know about T-SQL within an SSRS, but it will work in a Stored Procedure.  
Tell me how 1, 2, 3 is determined, as there are other ways to pull off multiple-value parameters in SSRS.

<div>
they will probable enter them as a comma separated list in SSRS<br />
<br />
1, 2, 3
</div>


they will probable enter them as a comma separated list in SSRS

1, 2, 3

<div>
any query that you would suggest with SSRS?
</div>


any query that you would suggest with SSRS?

<div>
<div class="content wysiwyg-content">
I have the following query<br />
<br />
Select * From Table<br />
Where AssetType &nbsp;IN(1,2,3)<br />
<br />
How would i change it so that there would be a variable for the items being passed in something like this?<br />
<br />
<br />
<br />
DEClare @AssetList as varchar<br />
<br />
Select * From Table<br />
Where AssetType &nbsp;IN( @AssetList)<br />
<br />
This will be used in a SSRS report
</div>
</div>


I have the following query

Select * From Table
Where AssetType  IN(1,2,3)

How would i change it so that there would be a variable for the items being passed in something like this?



DEClare @AssetList as varchar

Select * From Table
Where AssetType  IN( @AssetList)

This will be used in a SSRS report

IN with variable

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.