LutzM (2/10/2012)

---

Here's a slightly different approach using a in-line table-valued function (itvf).

I don't know if it will even compile since I have nothing to test against (your sample data require...

GilaMonster (2/20/2012)

Yes, you need a column to compare the table you're deleting from to the subquery, regardless of whether you're using Exists or IN

DELETE FROM <SomeTable>

WHERE <PK Column> IN (SELECT...

HowardW (2/20/2012)

---

I'm pretty sure you can't accomplish this with INTERSECTS alone - you'd need to break out into dynamic SQL, build your key column list from the table metadata and...

GilaMonster (2/20/2012)

---

EXISTS returns true or false depending on whether a row exists in the subquery or not, so your example will delete either all the rows in the table (if...

estimated group by plan attached. Same problem here. execution with actual plan never finishes..

Jack Corbett (2/10/2012)

Yeah it's not a performance issue, but if you aren't getting the right data then does performance really matter? I'm normally concerned with getting the...

The grouping is not happening in that queryplan. I attached the queryplan for the previous suggestion to first put the results in a temp table and then group the results....

Ok. I let the query run for an hour, no result. Seems like the actual executionplan is impossible to get.

Anyways, here is the estimated one, if that helps..

Hmm.. Its a bit difficult to get the actual execution plan for you. When i turn on include actual execution plan the query just goes on forever. I've been waiting...

Eugene Elutin (2/10/2012)

---

I would try to SELECT INTO #table the result of the query including the calculated columns used for grouping (without grouping itself), then the final query would select...

Thanks for both your answers and sorry for my late reply.

First of. Here is DDL of the main selected table "PostingYTD", its indexes and the cross joined functions that create...

Cadavres suggestion returns the same amount of rows as the original query, but running at a speed of aproximatly 15 seconds. I have not double checked the summed amounts so...

English is not my first language, so i might not get my point across well.

For simplicity, lets say i only grouped by two columns in the query. Account_FK and Company_FK

In...

The reason for the...

Im currently looking into the temp table suggestion, and from a quick test i looks like it will increase performance from 2,5 mins to merly seconds. So thank you very...