Hey everyone. I'm having trouble with this task I need to complete for work. The first part of the project required me to read data from a CSV file into a MS SQL database, which I've completed. The second part involves creating some Stored Procedures in order to report on the number of calls per minute, and then to display this data in a line graph. I'm hoping someone here will be able to help me with this, because I'm quite lost.
Also, the call start events that are logged in the CSV are in full datetime format, though I've been able to use datepart to extract only the minute values, which I've yet to do anything with other than view them within the Query.