Hi,
I have quite a complicated request to do in sql.
I've got on table with 3 fields (id, field1, field2) and I have to
process a request on each of the records, one by one, and then
determine if the status is OK for each records
For example, I would check if the sum of field1 and field2 is greater
than 10.
What is the best way to do this ? It has to be done in a stored
procedure. I can't return the status for each one of the records, so
should I store it in a temporary table and do a select on it from my
tier application (vb.net) ?
Thx
Sam