GSquared (4/20/2012)

---

mtassin (4/19/2012)

---

GSquared (4/19/2012)

---

Once the data is on the remote servers, I have various T-SQL jobs in SQL Agent that do all the more complex transformations and distribute the data...

jfogel (4/23/2012)

---

GSquared (4/23/2012)

---

rudy - Doctor "X" (4/23/2012)

---

Yes, a disturbing trend in a number of ways ... enough said.

However I am not affected since my only online 'presence' is SSC, almost...

rudy - Doctor "X" (4/23/2012)

---

Yes, a disturbing trend in a number of ways ... enough said.

However I am not affected since my only online 'presence' is SSC, almost daily, and...

terrance.steadman (4/23/2012)

---

Greetings jfogel,

Sometimes what is considered "negative" and what is "sanitized" is completly a matter of opinion. That is the point I was trying to make about the reason...

It sounds like recompile issues.

A common cause of that kind of thing is if a procedure is working on data with very different distributions depending on the input parameters. ...

Join the table to itself on ParentID = ChildID. At least, that's what it looks like to me.

The table is poorly designed. An adjacency hierarchy should have ParentID or...

That sounds like a problem with untuned queries, more than a problem with Reporting Services itself.

Have you looked into what the drop-downs are getting their data from? Is it...

That's pretty common with views.

Think of it as having the whole View definition as a sub-table in your From clause. If you won't use the whole thing, you'll still...

If a prospective employer asked you for a list of everyone you've ever known, and for details of every interaction you'd ever had with all of them, they'd recognize that...

If you:

A) Describe what the cursor is doing

B) Provide the table definitions (Create Table scripts)

C) Provide sample data (a dozen or so Insert statements)

then we can probably (almost certainly) help...

Solution is, tell whomever put the data in the table to do it again, but do it right this time. Don't split the data across multiple rows like that.

Jeff Moden (4/22/2012)

---

GSquared (4/20/2012)

---

I tested two-step upserts vs Merge, and [font="Arial Black"]it[/font] was faster in most cases in my code. But [font="Arial Black"]it[/font] isn't always faster, and possibly not...

Brandie Tarvin (4/23/2012)

---

What you might consider is either a subquery, CTE, or TempTable for your initial Tally Table pull. Pull just the numbers from the Tally Table that you need...

L' Eomot Inversé (4/21/2012)

---

kangarolf (4/21/2012)

---

This is interesting.

So out of these which would result in a calculation for ALL numbers in the tally table and is there a way of telling?

WHERE...

Explained.