Viewing 14 posts - 1 through 15 (of 15 total)
SQLRNNR (10/31/2011)
L' Eomot Inversé (10/31/2011)
Thomw (10/31/2011)
Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL
Rather than...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
October 31, 2011 at 10:31 am
Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
October 31, 2011 at 8:26 am
<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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
October 31, 2011 at 8:19 am
aahhh... Got it. thanks for answering the n00b question.:-)
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 5:10 pm
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 5:02 pm
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 3:31 pm
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 10:59 am
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 9:49 am
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
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 8:08 am
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
April 23, 2010 at 8:06 am
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
September 23, 2009 at 11:10 am
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
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
September 23, 2009 at 10:49 am
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
September 23, 2009 at 10:46 am
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...
--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)
September 23, 2009 at 10:12 am
Viewing 14 posts - 1 through 15 (of 15 total)