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]
FROM [Corporate].[dbo].[LDAP] where EMPLOYEENUMBER = (@List)