|
Posted by thetaamommy on 10/24/07 16:27
Hi David :
Thank you much.
This gives me 2 values, min and max.
but, I will have a total of 4 persons on philosophy and it could be
either 0 or 1 or 2 or 3 or 4 persons in philisophy.
Is it possible to do a set operation for that ?
What i came up with is 4 sql set stmts.
first one is insert stmt of a random philisopher in temp table:
second will be update stmt and in where clause excluding what is
already in temp table
third stmt is another update to 3rd column excluding the two already
in temp table
and fourth stmt
Is there a better way ?
Thank you
Navigation:
[Reply to this message]
|