There are multiple ways of doing the same. one option is to use the dynamic sql query. Example:
CREATE procedure [dbo].[sp_proc_select]
(
@bankId varchar(4096)
)
as
begin
exec('select * from tbl_bankmaster where bank_id in (' + @bankId + ')')
end
exec sp_proc_select ('5,28')
Another option is to pass the XML as parameter and then use in the query or you can also use split function inside the stored proc if you don't want dynamic query....