I think u r right we should avoid cursors as far as possible...I have a query of Dynamic sql how can I use it in a while loop?please help:confused: