You have wrongly declared @criteria as int. It should be varchar. First you have to form a query. Then execute it..

Pls check the below code.

DECLARE @CriteriaA VARCHAR(10), @CriteriaB varchar(MAX)

SET @CriteriaA = '1, 2'

SET @CriteriaB = '(''dog'', ''mouse'', ''cat'')'

declare @sql varchar(max)

Set @sql = 'SELECT * FROM #Rookie

WHERE CriteriaA IN (' + @CriteriaA + ') AND CriteriaB IN '+ @CriteriaB

Print @sql

exec(@sql)