Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select statement with exists
Sorry to disturb, but from my point of view this code : /* update RqDocuments set RqDocuments.FileDirectory = 'c:\Projects',VersionNumber = VersionNumber + .0001,VersionUserId = 99, VersionDateTime = Sysdate, VersionReason = 'RequistePro Document Update' where exists (select A.ProjectId...- datuk04
- Post #10
- Forum: Oracle: All versions
-
<= Date gives odd result
try this... WHERE DateOnStudy <= CONVERT(DATETIME,'2002-08-13 00:00:00',102) '//------------------------- ' your [DateOnStudy] colums datatype should be DATETIME good luck.- datuk04
- Post #3
- Forum: Microsoft SQL Server: Programming
