No point in admitting defeat.

I changed your where clause with mine and it gives the correct output for the sample data, tho I'm not sure it will for your actual...

Please post the ddl and data so I can have a better look...

Instructions here :

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Check out the backup history or sql logs to see if there's really nothing and noone rebacking up the db. Nothing else would make sense to me atm.

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...