Prakash Heda (6/24/2008)

---

I used it it a little different fasion: if you are not able to fix it then you can use this also...

procedure stores data in a temp table...

Thanks, but no luck trying DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS then running the EXEC statement with WITH RECOMPILE.

Same results. The EXEC statement runs fine alone, but I end up...