Outer join to a calendar table to ensure that there are no missing months, order by the date, and it should work.

Instead of inventing the word "beginnator" as the opposite of terminator, how about "initiator"? It's already an English word. Statement initiator vs. statement terminator--I think that sounds reasonable.

I've seen some...

I blame management, almost entirely. They can stifle the most talented programmer, enable the most incompetent programmer, and prevent junior programmers from ever realizing their potential. You cannot train your...

Bad comments:

- Comments that are factually incorrect

- Commented code (anything that has actually been checked in with commented code)

- Comments that are misspelled or use improper grammar (personal pet peeve)

-...

Brandie Tarvin (3/12/2015)

The "5" thing was my attempt to say "everything should be gray before the code is run and anything is checked". I guess that's not what you saw?

And...

I have more C# experience than SQL experience. I prefer a job doing both, but have tended to bounce back and forth because DB Dev and App Dev are often...

The following is the DDL and test data that I used. The query returns three rows.

CREATE TABLE SensorData (StartTime int, Offset int, Sensor int, SensorID int)

INSERT SensorData VALUES

(0, 1,...

Gerry Roston (2/23/2015)

---

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,...

If the starttime + offset given is the "first" value for that group, then it is also the smallest value in that grouping. Try the following. Note the "ORDER BY...

Can you post sample DDL? The answer to your question depends on the data types of StartTime, Offset, etc.

Not joking, though I appropriated my husband's experience for that one....

I've been an employee, contractor and consultant. Many of the places I've worked have not allowed any personal devices. No USB drives, no access to personal email, no smartphones plugged...

I worked in manufacturing for a while and I really enjoyed that industry.

I was doing app dev and DB dev. I loved every chance to get onto the factory...

GilaMonster (2/3/2015)

---

I would use an integer and define that it's a number of minutes, seconds or hours as...

A bit off topic, but it's already been brought up in this thread. What is best practice for storing time intervals in a table? This is relevant to a system...