SQLRNNR (10/31/2011)

L' Eomot Inversé (10/31/2011)

Rather than...

Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL

<tosses two cents into the pot>

As someone who has been assigned different applications and systems with minimal training I have spent a great deal of time in forums and have...

aahhh... Got it. thanks for answering the n00b question.:-)

Thank you Mr Magoo & Wayne Works like a charm.

I didn't realize that the sort order when pulling from 'two' tables made a difference. Is this because of...

Well didn't really progress any closer to the solution then what you have already given me, but I did learn some about Apply and table Variables today. This is...

This is what I get when I run the query against the test data

2010-04-22 07:27:00.000M01USDPUSDP7 LAKES

2010-04-22 08:22:00.000M12USDPUSCP

2010-04-22 09:21:00.000M01USDPUSDP7 LAKES

2010-04-22 09:42:00.000M12USDPUSCP

2010-04-22 10:02:00.000M01USDPUSDP7 LAKES

2010-04-22 11:44:00.000M12USDPUSCP

2010-04-22 11:45:00.000M01USDPUSDP7 LAKES

It seems to be only referencing...

OK, let's try this again<G>

Hello,

I work with emergency response vehicles and we track what they are doing by unit status codes. These records are in a single table in...

mister.magoo

Thank you for the reply. Let me review the links in WayneS' sig to ensure I'm posting the test data correctly and will then put some up.

thom

WayneS

Thank you for the review of you forum's practices. I apologize for not lurking longer before posting. I had gone back and forth on whether to post in this...

Thanks Matt, corrected the error and all is good. After I get this report out of the way I'm going to work on your previous suggestion. It looks...

Matt,

I'll take what you suggest and give it a try. Again thank you for your time and patience with my basic questions.

Thom

I've now built a case stm which works standing alone, but fails when part of the query. Either I'm missing something simple, or it doesn't work like this. Could...

Matt

Thank you for the quick reply. I should of defined my fields a little better. It's not a timestamp. This is how the Dispatch_Month field is built in...