Search table against variable list.

[abenitez77]

I want to run a select command on a table against a value in a variable

Declare @TableNameHeader as varchar(100)
set @TableNameHeader = 'Header1,Header2,Header3'

Select * from nj_toys_claims.dbo.tblTables where TableName IN(@TableNameHeader)

I get no records returned and the 3 values exist in the table.

 

[markros]

You need to split the values into separate rows, so

select T.* from nj_toys_Claims.dbo.tblTables where T.TableName
IN (select Item from dbo.Split(@TableNameHeader,',')

See split functions in this article

http://www.sqlservercentral.com/articles/Tally+Table/72993/

PluralSight Learning Library

 

[abenitez77]

thanks! this worked like a charm.