ajaykini (11/8/2008)

---

Well as i mentioned after a particular member gets more than 950 members below the nesting error is seen when leg count is link is activated.

Please advise what needs...

There are many such functions, but none of them are built into SQL Server.

An inline function that uses a recursive CTE instead. Like this:

CREATE FUNCTION dbo.BSGGetReports3( @IncludeParent bit, @user-id int )

RETURNS TABLE AS -- inline table-valued...

Question: Your function is referencing a "Status" column that is not in your table definition?

You need a GROUP BY, and as this isn't MS-Access, I don't think that the #..#'s are going to work:

SELECT Booking.Lesson_Date, Lesson_Type.Lesson_Desc, COUNT (Booking.Lesson_CatId) AS TotalTestAndSessions

FROM Session_Information

INNER...

Please show us what you already have for your stored procedure.

Jeff Moden (11/7/2008)

---

rbarryyoung (11/7/2008)

---

Local variables are entirely local in scope and visibility: whereas dynamic SQL makes a new batch scope for every invocation that will not be able to see...

As I recall, the next tip in my presentation is #5: "Master Key is NOT Optional", and I did not see you creating master keys for your databases, so you...

Did you check all three error message locations?

1) sys.transmission_queue (source and target)

2) Initiator's Reply Queue

3) SQL Server Error Logs

Right, I was just getting...

We cannot see the error message. If it is in XML then either post it as a txt attachment or just cut and paste out the text message portion...

A Cursor-based recursive function? Wow. That is going to be slow.

OK, so is anything showing up in [RecordSalesQueue] on [actiondb] (the Initiator Queue)?

Then they should not be in variables in the first place,...

Glad I could help!