thanks Gila .... 🙂 my lead asked me to use table variable instead so it was confusing...

well i have used temp tables now