Can't figure the IN statement

[Kristen]

You can't do

where MyColumnName in (@MyParameterList)

Similar question to one just recently asked:

Use of WHERE IN with a list in SQL 2008 R2

Having trouble getting the following to work. I have a known list of IDs, where I would like to select details from the database. I am using the following resulting incorrect syntax near ',' Any thoughts? DECLARE @List int Set @List = 710800168,710813843,710799889,710745846,710839725,710821798,710836139,710829653,710846897,710789736,710840949,810813894,710833293,710825216,810818478,710721686,710722817,510733823,710840949,710824166,710726615 SELECT TOP (1000) [ia_Record_Date] ,[DISPLAYNAME…

Or you can use a Splitter Table Valued Function to convert the @List into a one-value-per-row and JOIN that to your table.