Variable giving error Must declare the scalar variable "@HeaderID" in tripple Cursor Script...

So that error message would typically mean that you are using a variable @HeaderID which you have not declared. If you think that you have, you need to look twice at your DECLARE statement. I say not more.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se