I have gone through the book back to back and I found the tips and trciks very useful. However, I would like to develop further on the example give in the second site.
I have a situation where a product has many sizes (different sizes with different stock values). The database structure and stored procedure described in the example is certainly not applicable here.
I am thinking of creating a join table, removing the stock columm from the product table and add it to this join table but I am not sure how to write stored procedures that fetches same product, diffrent sizes and stock. I would appreciate if someone could help out.