I have a query that gets a few fields from an oracle 9i dB based on a date Reporting services 2005.The results dont match where clause in the query...
select to_date(ENTRY_D ATE),sum(amount ),substr(commen ts,1,10),store
from old_ap_invoice
where trunc(entry_dat e) = '08-JAN-08'
And comments like '%GRN%'or comments like'%DSD%'
and store ='245'
group by to_date(ENTRY_D ATE),substr(com ments,1,10),sto re
select to_date(ENTRY_D ATE),sum(amount ),substr(commen ts,1,10),store
from old_ap_invoice
where trunc(entry_dat e) = '08-JAN-08'
And comments like '%GRN%'or comments like'%DSD%'
and store ='245'
group by to_date(ENTRY_D ATE),substr(com ments,1,10),sto re