Why hasn't anyone called into question the firewall/proxy yet? That would be the first thing I'd check.

Brian McGee-355525 (10/7/2010)

---

Hi

I have an SP that works on a few thousand rows at a time, and as part of its work, does multiple inserts and updates.

The Merge statement would...

markganley (10/7/2010)

---

Hello,

I have carried out continuous profiler traces. Nothing is exceeding 10 seconds. Everything is executing as should be and there are no hangups. I may try pausing/stopping the mirroring...

You are using SSRS right?

Yea that looks like a timeout to me. The way to know for sure is to see if that error message displays after the number...

another thought - have you done a profiler trace alongside your perfmon stats collection? Thats probably what Microsoft support would ask you to do anyway.. this smells like the footprint...

I don't really see how anyone besides you or someone in your organization that had a hand in designing/implementing that data warehouse would be capable of writing up a document...

I think using a tier subreports would suit your purpose. If you need a refresher, check this out - http://msdn.microsoft.com/en-us/library/ms160348(SQL.100).aspx

It might make sense to maybe set up an SSIS package that captures what has changed since last run (having a last_update_time column on the tables helps alot here), and...

samalex (10/6/2010)

---

Hey Guys --

Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll...

maxx.flavin (10/5/2010)

---

Already having the report created and working for a single EmployeeID, is it possible to add an outer report at this point to wrap the current one in? ...

Just eyeballing the query really fast, looks like the syntax error barf is from the second inner join to the third table, you have "INNER JOIN FROM".

Thats not going...

wware (10/5/2010)

---

I regretfully find myself in the 66% majority who answered this question incorrectly. Hopefully, all 529 of us learned something. I know I did. Thanks for...

I think you will have the best success by writing the report for a single employee id, then "wrapping" the report by making it a subreport of another report's tablix...

dynamic sql is also more susceptible to sql injection. you might find it cleaner to have 2 queries with different formatted where clauses and an if statement that chooses which...

preensheen (10/4/2010)

---

Hi All,

How can I have the dynamic column names at the detination, My colums name chages every quater. I mean to say, the date should be added up...