Free for PREMIUM members
[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now
INSERT INTO temptbl_Stops
SUM(CAST(DATEDIFF(s, StopDate, StartDate) AS NUMERIC(4, 0)) / 60) AS StopTime,
GROUP BY StartDate,
HAVING ( SUM(CAST(DATEDIFF(s, StopDate, StartDate) AS NUMERIC(4, 0)) / 60) IS NOT NULL )
ORDER BY StartDate
Open in new window
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
'Assuming that the query is already saved as a stored procedure on your server
Dim con As New System.Data.SqlClient.SqlConnection("ConnectionString to your database")
Dim cmd As New System.Data.SqlClient.SqlCommand("qry_Stops") 'Or another name
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = con
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.