SELECT machine.MachineID,

DATEADD(mi,t.Number,'20100522') AS SampleTime,

CASE WHEN ABS(CHECKSUM(NEWID()))%2 = 0 THEN 'Off' ELSE 'On' END...

Jeff Moden (5/21/2010)

---

I recognized this whole thing as a very simple and classic "how many times did the machine turn on or off" problem with a now classic solution. ...

So Jeff, do you provide new reading glasses with your code??? For the life of me, all I can do is apologize for not seeing my own data. ...

I take it we are in agreement now that K9ID=1 does not have a frequency change as defined in the query and should not have been returned in your results,...

Hi Jeff,

Well, this one is closer, but sorry to say still not 100% correct.

When I ran this:

SELECT K9ID, MedID, Dose, Frequency

FROM #RX

ORDER BY K9ID, MedID, RxStartDate

against #RX, that...

Jeff, I posted my last message without seeing your last 3 messages (did not refresh page), so I will have a look now at what you posted and get back...

Okay, after studying the queries and the results, I am confident that these queries only deal with Frequency changes. This sample data is meant to test every possibility that...

Ah, I see what I did. All along it was my plan to get this query on Frequency working right, then I could just change all the references from...

I'm not trying to be daft, but I don't see a change in the requirements. Maybe I'm just too close to it to see. I added one new...

My goodness I'm getting brain dead Jeff! Thanks for the kick! I've saved your post to my computer this time so I don't ask a third time!

Sadly, here...

Jeff, I think I have gremlins in my computer... today when I added all my other joins to your code, it worked perfectly right out the gate. And, I...

mister.magoo (5/15/2010)

---

DECLARE @TABLE TABLE

(

K9ID INT,

Drug INT,

Dose...

Jeff Moden (5/14/2010)

---

BWAA-HHAAA!!!! Yes, I did warn about it but you joined it with 5 other tables and say MY code uses a lot of resources? 😛

It all depends on...

tosscrosby (5/14/2010)

---

Never stupid if you've learned something and shown the gumption to make attempts at resolving your problems first and to understand suggested resolutions second. We all are...

Just getting an internet connection again (I'm in the boonies with not so much as even dial up). Mister.Magoo, what you did gives perfect results! I have saved...