kgittinger
asked on
open query guidlines
is there a difference between the SQL used via linked server (Open Query) than when running a query on the server itself? As an example where myfielddate >= '2/08/2011' returns an invalid sintax near '2'
ASKER
Unfortuantely this returns the same error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you still have issues, please post the complete query you're trying to run
ASKER
Thanks a million!
convert(char(10),myfieldda