April 14, 2011 at 5:22 am
I have data in the attached format which lists equipment owned by a person on a particular date. Homeno+name is a unique field.
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 order. While summarising the order should be similar
What query will get me these results ? Im using SQL Server 2000.
I have tried using group by but with no success
April 22, 2011 at 12:32 pm
That looks a bit like homework to me. What is your table structure? Sample data? What have you tried?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply