Bobby Tennis 12:00pm 2:00pm January None
Timmy Tennis 12:00pm 2:00pm February None
Joyce Tennis 1:00pm 3:00pm February None
Dennis Tennis 12:00pm 2:00pm January None
Sue Tennis 1:00pm 3:00pm January None
Bart Soccer 12:00pm 2:00pm January None
I would like to select Distinct Activity records associated with the Start and Stop Time. For example if I selected distinct Activity associated with Start and Stop times I should be able to pull up the following:
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.