I have a set of sql records from a stored proc that look like below:
Basically date times and per each, an ID (the ID represents a specific business service.
For example, ID 1 is let's say "Service A", ID 2 is "Service B", and so forth.
What I'd like to do is have the following output:
DateTime Service A Service B Service C
The Service columns are a count/total of the instances that ID 1, 2, 3 etc come up for each date. So in the above, Service A will have 2 and Service B 4.
How could this be done? I hope I have provided all the info needed! Note that date and id comes from two different tables.