Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-18 : 18:21:48
|
| Sushma writes "I am working on a report in SQL Server Reporting Services 2000.SELECT TOP 200 * FROM necc.dbo.vw_rop_report_profit_per_call WHERE [Call Day] = case when @callDate = '' then [Call Day] else @callDate end >> I have apromt for the user to enter the date.>> If the user does not enter any date, then the report will show all the first 200 records.>> This query is running too slow.To increase the speed of the report , could somebody help me build the where clause only when something is in the filters ?Thank you," |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-18 : 18:34:39
|
| Explicitly write out the columns you want returned instead of using *. Do you have an index on [Call Day]?Tara Kizeraka tduggan |
 |
|
|
|
|
|
increase the speed of the report