I have data in the attached format which lists equipment owned by a person on a particular date.
Homeno+name is a unique field.
Im using SQL Server 2000.
I need the output to summarise the equipments owned by a Homeno+name on a particular date.
If similar equipments are owned by different Homeno+name they should be reported in the same order
For eg, here 2B owns same equipment as 1A but entered in a diff or
View Complete Post