Hello Group:
Can anyone tell me what I am doing wrong in my first SQL Statement? When I
do not add the DATEDIFF in the where clause: I get the desired records. In
the second Query: I have verified that when this is ran: the value for
DIFF is at least a 2 (which would be greater than 1). However: I cannot
seem to get the query working when using the first query. Any suggestions
would be greatly appreciated.
-------------------------------------------------------------------------
QUERY #1
-------------------------------------------------------------------------
SELECT
i_ID, s_UniqueName
FROM
tPGOrderFiles P
INNER JOIN t203 I ON I.Ohornm = P.i_OrderID
WHERE
P.i_OrderID = 1042429
AND I.Ohstat NOT IN ('S', 'V')
AND DATEDIFF(DAY, d_DateUploaded, GETDATE()) > 1
-------------------------------------------------------------------------
QUERY #2
-------------------------------------------------------------------------
SELECT
DATEDIFF(DAY, d_DateUploaded, GETDATE()) AS Diff
FROM
tPGOrderFiles
WHERE
i_OrderID = 1
Thanks
Andy Mills
Programmer
Regency Thermographers
717-765-3572
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
http://www.regencythermo.com <http://www.regencythermo.com/>
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
