Dear all
Please see the attached screen shot of the query and the output. I am almost
there but I have run out of ideas on what I can do to post process further.
My final output I want something like this:
1 Haemogram Report 1 Routine
Haemogram
1 Haemogram Report 5 Diff. Count
(Mature Cells)
1 Haemogram Report 10 Special
Investigations
5 Haemogram Report 1 E.S.R.
3 C-Reactive Protine 1
4 Urine Analysis 1 Physical
Examination
4 Urine Analysis 8 Chemical
Examination
4 Urine Analysis 10 Microscopic
Examination of Centrifugalised Deposit
ie. The Row 4 is clubbed with row 2 and row 9 becomes row 4
The idea is that all the cTitle are clubbed together but in the order they were
originally selected, thus MIN(A.iSrNo).
The second grouping is cSubGroup, together but in the order they were defined,
thus MIN(C.iSrNo)
Please advise
Kind regards
Bhavbhuti
