[b]Command prompt query optimization[/b]

[abcraj75]

Hi
I think my query in command prompt of Crystal reports 2008 is taking longer timer to read records:
Query:
Select distinct name, date from salestable where date>add_months(sysdate, -36)
I tired
select DISTINCT price_name, trade_date from era006_forward_prices where trade_date>DateAdd('m',-36,CurrentDate)
but that seems not to work.

Please suggest me another alternative to be used in crystal reports

 

[Madawc]

Check Database > SHow SQL. You'll probably find that the date check is not there, i.e. it is being done by your machine rather than the server.

Code your adjusted data as an SQL Expression. That should fix it.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[abcraj75]

I cannot use a sql expression since I am using command prompt along with the table, this does not allow for sql expression and group by server option. So please suggest me on the query.

 

[Madawc]

No idea. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

Why are you using a command for this? Are you linking the command to other tables or is it the sole datasource of your report?

-LB

 

[ianoctdec]

Does the following update make any difference?

Select distinct name, date from salestable
where
to_char(date, 'YYYY/MM/DD') > TO_CHAR(add_months(sysdate, -36), 'YYYY/MM/DD')



Dana