Run this query, describe the result set - better still, post the result set:

SELECT YEAR(OrderDate) AS OrderYear,

AVG(TotalDue) AS TotalDue

FROM Sales.SalesOrderHeader

GROUP BY YEAR(OrderDate)

stephen.staple (11/23/2011)

---

Thank you GSquared. I actually ended up with a very similar solution to yours.

First I defined a function:

create FUNCTION [dbo].[fn_GetTopMatch1](@LoginID AS int)

RETURNS TABLE

AS

RETURN

--

SELECT ...

Gangadhara MS (11/23/2011)

---

NodeiD limiting also didn't worked for me.

Actually another SP is calling this sp inside the cursor so not able to find the exact culprit.

Something can be done...

Gangadhara MS (11/23/2011)

---

in this query there is a problem now

WITH DirectReports(Employee_ID, Parent_ID, PositionName, Position_ID, Team_ID) AS ...

NodeID limiting works well providing the rCTE has a single anchor. If it didn't work then it was probably incorrectly written....

Use a WHERE clause, you %$£$%%$$ $%$££ %^^&%$£ 😉

Unless you're working for Microsoft, you're unlikely to have...

What a really nicely written article to start the day off with, very enjoyable.

Suresh, have you tried using CROSS APPLY to partition the rows into "records" as an alternative to...

So, what values have you tried for MAXRECURSION, and what was the effect?

There is a method you can use to restrict the number of recursions to an absolute number without...

Heh - Remi this looks like motive, when the rest of the world is wondering why the h3ll you want to spend another minute in Mycelium Mansions....

Ninja's_RGR'us (11/21/2011)

---

I'm considering it...

Move. Some of these fungi can cause serious respiratory problems. It's not worth taking the risk.

It won't work without the knickers and pencils;-)

Koen Verbeeck (11/21/2011)

---

I kid you not.

I'm even surprised myself 🙂

We even had an Indian Summer that was better than the...

MysteryJimbo (11/21/2011)

---

Koen Verbeeck (11/20/2011)

---

Sean Lange (11/18/2011)

---

I don't think you can...