title: Examples of challenging real world examples or situations resolved using stored procedures
body: <p>Currently I'm working on gaining the different relevant skills in becoming proficient with database. Just finished reading up on stored procedures and wondering how could it apply to real world situations if any? </p>
  
  <p>Hope someone could list a number of challenging real world/web problems resolved or requiring resolution by stored procedures. Any web/books/list of resources with more of such real world problems or challenging examples would be gladly welcomed too.</p>