Or, to be a bit more serious, tie breakers pass if all other things say so as well. I do, however, agree that the board be made of an...

Link not working for me.

Based on a quick look at the mTVF you are using, one quick suggestion, try rewriting it as a stored procedure and use the stored procedure to load a temporary...

Paul White NZ (4/8/2010)

---

Lynn Pettis (4/8/2010)

---

I rewrote your MLTVF as an in-line TVF last night and was testing it against your scalar function and it was still slower, approx 3...

To be considerate of individuals seating on the MCJ board at conferences I recommend that there be more than one board at such events as SQL Saturday, PASS conferences, etc....

Colonoscopy

dndaughtery (4/8/2010)

---

I made a mistake in my database I'll call StateCaseLevelData. I have a back up of it. I want to create another db called StateBU with the backup for...

pnmm (4/8/2010)

---

Please remember, my rewrite was done in a vaccuum. I had no tables, sample data, or expected results with which to test my code. I can only hope it...

pnmm (4/8/2010)

---

Thanks a lot guys!

So, check out my conclusions after trying your suggestions.

1º Comment:

Lamprey13 and Jeff Moden: You were right, i could re-write my MTVF in order to use ITVF...

Not adding anything here, just confirming that you are using SQL Server 2000 SP 4 as indicated in your original post.

Now stop that ... 😛

Lowell (4/8/2010)

---

i just re-wrote it as well, but the math is quite not right; i'm basically using multiple CTE's to do the intermediate variables as columns, as soon as i...

nano2nd (4/8/2010)

---

Thanks, it worked as you expected. It applies the function to the first row returned from the select. How do I apply it iteratively to each of the rows...

Check out this link: http://msdn.microsoft.com/en-us/library/ms189063.aspx

nano2nd (4/8/2010)

---

Suppose I have a function that performs some mathematical operation on the input parameter x and returns a value y:

select dbo.MyMathFunc(10)

Is there a way to apply the function to...