SQL Server 2005 or Visual Studio 2005 - writing my first procedure, any tips or good starting points?

I'm about to write my first procedure to check if yesterdays data exists in one database, and if it select some of the data, use a count and insert that da开发者_JS百科ta into another database. If the data doesn't exist, then send me an email.

I'm using SQL Server 2005 and I'd like to ask the community for tips or good starting knowledge on smart procedure coding.

Thanks!

Here is an article on MSDN about stored procedures on SQL Serve 2005 that should help.