set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
select * from xc.services where service_id in
(select service_id from xc.business
where charindex(business_code,@business_code)>0)
set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
exec('
select * from xc.services where service_id in (select service_id from xc.business where business_code in ('+@business_code+'))'
)