Call me Ishmael
This week I’ve been chasing my own white whale. Another developer came to me with this little problem. A query he was trying to run over a linked server to an Oracle database was returning unexpected results. Here’s his original query: select count(order_num) from openquery(PROD, ‘select t2.order_num from myschema.mytable t2 where open_date < to_date(”01-JAN-2011”, ”DD-MON-YYYY”) […]