how to concat multiple rows with same id in sql

Use this

... 
where id_col in(2,3,4)

I think sp_executesql is the way to achieve what you expect to have.

---

Many Thanks & Best Regards, Hua Min