jamppi
asked on
sql query count failed sessions per user and 7 day period.
Hi!
I need to count the failed sessions per CustomerName for this week or 7 day period.
Customer table.
DeviceId, Custname,,,,,,,,,,,,
session table
Sessions_Id, DeviceId, on_date_time, Off_Date_Time, Complete,,,,,,,,,,,,,
if complete is false the count it.
output should for be distinct " custname - 'Number of false completes""
I need to count the failed sessions per CustomerName for this week or 7 day period.
Customer table.
DeviceId, Custname,,,,,,,,,,,,
session table
Sessions_Id, DeviceId, on_date_time, Off_Date_Time, Complete,,,,,,,,,,,,,
if complete is false the count it.
output should for be distinct " custname - 'Number of false completes""
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
I have included DeviceID in case you have two customers with the same name