RE: SQL stumper

2003-03-25 Thread Dave Watts
I'm stumped by a SQL sub-query that works stand-alone, but not when assembled into a query. This works: SELECT personid, dob FROM persons And this works: (SELECT personID FROM persons WHERE CAST('2003'+ SUBSTRING(CONVERT(char(8), dob, 112),5,4) as datetime) = '2003-07-21' AND

RE: SQL stumper

2003-03-25 Thread Dave Jones
To all generously considering this problem, the example I used is admittedly an artificial one, clumsily extracted from a multi-part dynamically constructed query. I was attempting to isolate from the original query the portion causing the problem. The original query looks something like:

RE: SQL stumper

2003-03-25 Thread James Ang
] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:23 AM To: CF-Talk Subject: RE: SQL stumper I'm stumped by a SQL sub-query that works stand-alone, but not when assembled into a query. This works: SELECT personid, dob FROM persons

RE: SQL stumper

2003-03-25 Thread Dave Jones
, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:23 AM To: CF-Talk Subject: RE: SQL stumper I'm stumped by a SQL sub-query that works stand-alone, but not when assembled into a query. This works: SELECT

RE: SQL stumper

2003-03-25 Thread Matthew Small
- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:58 PM To: CF-Talk Subject: RE: SQL stumper To all generously considering this problem, the example I used is admittedly an artificial one, clumsily extracted from a multi-part dynamically constructed query. I

RE: SQL stumper

2003-03-25 Thread James Ang
--- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:58 AM To: CF-Talk Subject: RE: SQL stumper To all generously considering this problem

RE: SQL stumper SOLVED!

2003-03-25 Thread Dave Jones
] -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:58 AM To: CF-Talk Subject: RE: SQL stumper To all generously considering this problem, the example I used is admittedly an artificial one, clumsily extracted from a multi-part dynamically constructed

RE: SQL stumper SOLVED!

2003-03-25 Thread James Ang
PROTECTED] -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:58 AM To: CF-Talk Subject: RE: SQL stumper To all generously considering this problem, the example I used is admittedly an artificial one, clumsily extracted from a multi-part