Hi Tim,

quote:

---

I realise this makes it all the more important to use an Order By clause, but I really don't want to run a dynamic select to get my final set.

---

what is dynamic when you add the DESC keyword in your statement SELECT * FROM #tmpIncentive ORDER BY ...(DESC)?

Cheers,

Frank

Edited by - a5xo3z1 on 08/14/2003 06:42:13 AM