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
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:
]
-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
, 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
-
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
---
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
]
-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
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
8 matches
Mail list logo