Hi,

One of the best pratices is not use CURSORS in procedures. try to check can your logic can be replaced with CTE's. i'm sure it should help u out

Hi,

 Note: XP_SENDMAIL will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.....

hi,

 just goto https://www.microsoftelearning.com/sqlserver2005/

and select topic and learn.

Regards,

Anand