Okay - I figured it out. I just needed an OR in the WHERE clause...

Alan,

Thank you! We were not familiar with the LAG command and that appears to do exactly as needed.

Doh!

Stephanie,

Thank you.

When I ran the 'fixed' query, see my Post #1662720, the query returned five rows - this is the expected result. With your query, there was no grouping, i.e.,...

Luis,

That would be tough. I have been working with a smallish example, but it has 771 data rows...

Doing some more digging:

If I change the select line to:

SELECT (StartTime + Offset) / 100, min(Sensor), max(Sensor)

The query runs, but the returned value is not what I need. However,...

Linksup+,

You are correct - dropping the divide does allow the query to run, but it no longer provides the proper result.

This post, https://stackoverflow.com/questions/4342370/grouping-into-interval-of-5-minutes-within-a-time-range, or one similar, may...

Stephanie,

Thanks for the reply.

StartTime and Offset are of type BIGINT - they are converted from datetime to milliseconds from epoch elsewhere.

Wound up reinstalling - wasn't that painful. Guess the first time, I created a named instance instead of using the default.

Thank you for taking time to reply. Sadly, neither reference was useful.

The answer turns out to be the configuration of the TCP/IP protocol with the SQL Server Configuration Manager....

Found a solution - I had to simply create the registry key (DWORD)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity 

and set its value to 1