I have 2 tables:
SchdLine and Details. There is a One To Many relationship from SchedLine
into Details
SchedLine has a Length field. Details has a Type field.
Each SchedLine record could have multiple child records in Details with
different Type values.
The result set should look like:
Length Type
----------------------
30 1
30 2
30 3
.
.
.
30 16
60 1
60 2
60 3
.
.
.
and so on.
Each record in the result set should contain a count of each type from
Details against each Length in SchdLine.
Hope that explains it.
Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people