http://ola.hallengren.com/Documentation.html

SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY TermianlID ORDER BY SchedLoadDate, Amount DESC /*In case you need a tie breaker for 1st*/) AS Group_RowID FROM dbo.tbl) dta

WHERE Groupe_RowID...

Can you create jobs in sql agent?

Not anymore :-P.

Please post the estimated execution plan... or the actual plan from the cache.

Looks like you have an hidden triangular join but I'm not 100% sure.

Agreed, upgrade for BI, maybe for compressions if you're on standard. I don't see many other reasons to.

I have the same problem... if somehow it increases the priority of the ticket ;-).

HTH, I'm...

Read the whole thread...

http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/47f12e8b-83c2-462e-aa26-b36e5620870b/

Also very useful

http://www.gotreportviewer.com/

Here... you'll have to get the right holidays for your country(ies) but the rest of it is done.

... and to resolve this you'll need to first get month(startweekdate) and join that back to the rest of the result set. I don't see any ways to do...

There's nothing like testing it for knowing for sure !

I was just showing you the identity function.

The idea is that once you have the "correct" data so just assign the identity with it (using the select into). At...

Please post sample data and required results... I'm just not getting the issue here!

Full text search might be an option (not an expert).

Otherwise please attach the actual execution plan.