saravanakumar.G (8/28/2013)
any help on this??? 🙁
Yes. If you insist on creating this proc, I recommend that you include a TOP 100 or TOP 1000 in the proc so that you're not using unnecessary resources. Using such a proc on big tables can really cause problems.
--Jeff Moden
Change is inevitable... Change for the better is not.