Every time I resort to Declare Cursor, Fetch, etc., I know there was
a Query that would have done the trick. I tried to create a temp
table/view and use group by and having, and then resorted to Select
Into, and Update...
Three tables A, B & C, but A is used just to get the right multi key
to use in B & C.
B is a one-to-many to C
I want to count the rows in C which have the multi key value, and
store that number in a fourth table which has the multi key found in A.
TIA,
Dennis
*****
Dennis Fleming
IISCO
www.TheBestCMMS.com
Phone: 570 775-7593
Mobile: 570 351-5290
