Oman. Ok, I sound like a broken record here, but my initial validation process didn't identify a hidden issue...

I just noticed that the last query is including cases that don't...

Excellent! Thank you for that variation!

This one works even better for me since I do need to pull other columns.

This is so great. Thank you again!

Oh man, that's great stuff. Perhaps I got a tad confused before looking at it from a different perspective. Basically eliminating the open complaints in order to find...

See, the thing is, I'm writing the query in SQL2008 Management Studio, but I'm running it against a SQL2000 db. (perhaps this post shouldn't be in the SS2K8 section?)....

I'm bringing this post back up for discussion.

The query I have didn't work out after all when I spent a little time validating it. (bummer) Here's what I got:

SELECT...

:crying:

Well, ...bummer.

I'll hold onto that code for when we migrate the db to 2008, which should be in the near future.

Thanks for your help!

Well then, that would appear to be a much more elegant and simpler solution! I'm running it in 2008. Why won't it accept the "EXCEPT"? I copied it...

Hmmm. I've never used "except" before. But when I run that query, it says "Incorrect syntax near the keyword 'EXCEPT'." ...?

But, wouldn't this theoretically just pull up all...

You know what? I was looking at the query sturner posted and I think it's actually right after all. I don't know what i did when i tried running...

Hehe. Too complicated? Yep, that is entirely possible. Like I said, I'm probably overthinking it. But when I first got the request I thought "Oh! that's easy!" and promptly...

Thanks for the effort, but that's not quite right.

Based on the following query, I've posted some sample data to give a better idea:

select caseid

into #OpenCases

from dbo.tblCase

where closedate = ' '

and...

Thank you, Seth, for all your assistance. You have been an immense help; I did move forward a bit on this process, thanks to some of your suggestions!

I used...

...Anyone else out there have any ideas for me?

I'm hoping I followed directions correctly...

I've posted some sample data, just for 2 routes, from the temp table: (Note, I excluded clientname, for obvious reasons)

--Create the temp table:

CREATE TABLE #Temp(

...

I think I figured out why the Odometers are not populating quite right...

My code separates out by Activity in two different cases for two different odoms: (note in the first...