Hello, I need some help with a SQL Server Query in Microsoft SQL Server 2008.
I have two tables, one with device information, and the other with device history. The device history is keyed to the device information id column.
In the devicehistory table I have 4 columns: id, compid, startalarmdate, endalarmdate. I have a script in my application that adds an entry when one of my devices goes into alarm, it puts in the id of the device into the compid column. It also writes the current date…
