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 |
|
tchinedu
Yak Posting Veteran
71 Posts |
 Posted - 2006-09-29 : 10:35:52
|
| Sorry Guys, I don't know how to delete this post, I think my question should be posted in a Crystal Reports Forum...maybe I'm approaching the query for the report in a wrong way. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-29 : 10:48:04
|
quote:
Originally posted by tchinedu
declare @BreakerTble Table(
Well, I will go for it:-------------------------------- Fully optimized version-- declare @BreakerTble Table-- (------------------------------Results:Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0.SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms.SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms. Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Optimizing a slow Query