Complex grouping
Hello All,
I am facing a scenario where I have to do a complex grouping. The following is the scenario...
1. Group list of people by their birthday.
2. Then Group them by FirstName.(Also list all the people with the same Firstname in Italics, even if their birthday does not fall under this group. Also do not repeat those records under their birthday group).
Eg:-
Name BirthDay
------------ -----------
Jan 2009
Jake
====
Jake Taylor Jan 10
Jake Chandler Feb 23
Kelly
====
Kelly George Jan 11
Feb 2009
Amanda
=====
Amanda Swann Feb 08
Wolf
====
Wolf Blitzer Feb 11
in this example Jake Chandler's birth day falls in Feb, but he had to go in Jan because of the Name grouping...
Any input is appreciated.
Thanks,
Jay
__________________
Regards,
Jayahar Aruchamy.
Life is all about expecting the unexpected.
|