>I guess this is why extreem programming advocates pair programing. With the input of several people you get a better routine than one person would write them selves.
>
>BOb
He-he. Well, this SP is nof finished yet. The most complicated part still remains...
Also I thought today, that I can have CartID stored in session variable and pass it. However, after further consideration, I think, I would leave the beginning of it as it is, because otherwise I would have to check, if it's a valid CartID or not and if it indeed belongs to the UserID
===========
Anyway, I now have another question. When I delete record in CartContent table, in addition to deleting records from CartDetail, I neeed to update ModiDate field in Cart table as well. And also set flag to D. How can I accomplish that? Is trigger the only solution?
If it's not broken, fix it until it is.
My Blog