Lynn Pettis (8/3/2012)

---

Here is part of your problem.

The function dbo.fnRubricDomainScoresMarzano is a multi-statement table valued function. What this means is that the function does not return its value (table)...

Lynn Pettis (8/3/2012)

---

Okay, we have another tvf, dbo.fnDomainCalculateMarzano. Can we get this code as well? By the way, I think I may know part of the problem and...

Hi Lynn,

Here is the DDL for [dbo].[fnRubricDomainScoresMarzano].

USE [TestDB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE Function [dbo].[fnRubricDomainScoresMarzano] (@SourceEvaluateeMilestoneID INT)

RETURNS @tempTable TABLE(RubricDomainID INT,...

SpringTownDBA (8/2/2012)

---

typical cursor flow is:

declare cursor ...

open cursor ...

fetch from cursor ...

while (@@FETCH_STATUS <> -1)

BEGIN

...

Thanks. I am trying the CROSS APPLY now and it has been running for over 14 minutes now.