Count

[Guest]

I have a multi Valued field in table. These values are repeated in many
rows. I want to count each value in all rows. Could you please provide me
query to do that.

e'g in the following table I want to know the count of Baseline = 2,
PMI_KCOO = 2, PMCS = 3, shopp2005 = 1, KC00ACT_AllMilestones = 3

Baseline(XX), PMI_KC00
Baseline(XX), PMCS, PMI_KC00
Allocation(XX), PMCS
KC00(XXX), PMCS
PMCS, shopp2005, K00ACT_ALLMILESTONES
PMCS, KC00ACT_AllMilestones
PMCS, KC00ACT_AllMilestones

 

[Marc Gravell]

Can you clarify your question? It doesn't sound like a C# one, but
perhaps we can point you in the direction of an appropriate forum...

If you *are* talking about some .net implementation, then the answer
will involve "foreach" and a Dictionary<T, int> for some T... perhaps
some LINQ grouping; but can't be more specific without context.

Marc