Vandom Check this out! http://databases.about.com/od/sqlserver/l/aastoredprocs.htm http://www.codetoad.com/asp_sql_stored_procedures.asp There are number of books of sql stored procedure available in da market. but only practice can help u out. Shwetaa