Tree Query Problem

You can use the logic to drop the temp table if exists. I updated my original post

IF object_ID('tempdb..#cteParents') IS NOT NULL
   drop table #cteParents

---

Satheesh

My Blog | How to ask questions in technical forum