Following SQL shows you a simple example of creating a procedure create procedure getInfo @account_id_1 varchar(12), @account_id_2 varchar(12), @account_id_3 varchar(12) AS select * from Orders where ORDER_NUMBER in (@account_id_1,@account_id_2,@account_id_3); GO EXEC getInfo '070213193415','070213193957',''