When coming to SQL from procedural programming you have to think in sets. The biggest mistake beginners make is to start looping through rows instead of manipulating sets

More about me and SQL here: http://sqlservercode.blogspot.com/
And here http://sqlblog.com/blogs/denis_gobo/default.aspx

SQL Server Programming Newsgroup: http://groups.google.com/group/microsoft.public.sqlserver.programming/topics