Have you tried this? :

and w.date >= s.startdate and w.date < s.enddate

bleister88 (1/14/2011)

---

In this line of code: INSERT INTO scada_archive.dbo.ScadaArchive SELECT * FROM #tagData WHERE DateAndTime < @sd;

you filter on DateAndTime... just filtering your remote table on that will return...

Do you know if there are plans to change that in 2008+?

I have the same problem on a 2k5 reporting project with the function "only" being used in...

Jason Thomas (10/26/2007)

---

i dont see any problem, maybe i didnt understand the question correctly...

u can have default values for all reports by setting their default values in the parameter...

I have to run to a meeting, but I think this can give you some pointers in the mean time...

http://www.velocityreviews.com/forums/t509239-error-subreport-could-not-be-shown.html

Wow, looks like an MS Access message got left over in SSRS... I wish...

What's the error message (sorry but I can't help without that)?

It should be posted in the output list when you run the report... and ususally google helps me figure...

A trace would be your best bet. I'd assume some sort of cursor client side with 1+ updates per row.

Unless you doubled the amount of transactions or activated an...

How to get the # of months from the temp results :

SELECT GroupCol, COUNT(*) FROM (

SELECT Distinct groupCol, MONTH(DateCol) FROM #tmp

) dta

I'd do all those calcs in sql server.

Save the base data in temp table.

Then for each group figure out how many months have data.

And do the final cals...

No it cannot be transfered. It can be created before the dynamic and used it it tho.

are you doing a defrag script?

If so you can just use this one......

Craig Farrell (1/10/2011)

---

*nearly sprays his tea all over the monitor upon opening the execution plan*

Yikes. Wow. :w00t:

Now, THAT'S a Table Spool. Just the estimate, I know, but...

Are the stats up to date and the indexes defragged (or rebuilt)?

... and 1 more point.

All those spools are generating 59 GB of data... 172 times the total size of the DB.

A couple more points to ponder on :

StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut"

That means that the server has given up on finding a "decent" plan to execute that query. So breaking...