Suppose you have 2 stored procedure, let's say a
GetProducts and a
Now, the GetProducts returns a list of products with a property that is "calculated" basing on additional calculation (the last time it was purchased, the number of resellers etc).
How can I be sure about the correctness of the data returned?
Do I have to call the GetProducts, then for each product call the GetProductDetails and finally check the correctness for each result? Or do I have to call the GetProductDetails only for a randomic product(s)?