title: learning how to write complex stored procedures
body: <p>i'm looking for good books and tutorials 
  about writing complex stored procedures along with common tricks and best practices
  commonly used by DBAs.</p>
  
  <p>all i usually find is the basic SQL Statement tutorials ,
  what i need are some good examples of Complex Data Selection 
  along with common tricks of how to correctly and efficiently filter data 
  for selection between multiple tables .</p>
  
  <p>i release this is hard to find , because Complex DB's are usually built 
  only in large projects and not for tutorials , but for the least i would like to find commonly used method applied by DBAs</p>
  
  <p>thanks in advance.       </p>