WayneS (4/12/2010)

---

BTW Paul, I really like the way you did the data diagram with grids under the tables (so much that I'll probably utilize that technique in any future articles...

Hey Steve,

I'm guessing that you are not serious here - but you should have posted a warning not to use that code! NEVER use %% functions for anything but...

Hey Arjun, no you are not missing anything - but I do cover all these questions...

Thank you all for the kind reviews (so far): Matt, Christian, Tom, Jack, Wayne, Steve, and Luke. I really appreciate it. :Wow:

It is per database - I think I mentioned that...?

No - not a joke...

heyzain (4/11/2010)

---

Note: The columns Col1, Col2, Col3 are of Varchar type.. i-e: each column can either contain numeric value or the value 'N/A' ... I want the average of columns...

This is the same error you made in...

The ERROR functions just return information for the last error - much the same way as @@ERROR and sys.messages work. I believe there is a Connect item open for...

Yup.

There are very few absolutes when it comes to SQL Server - and this is not one of them.

Read Kimberly's article - each...

tony.turner (4/12/2010)

---

Don't want to provoke any religious wars. However, going back to the original question, Kena has a table to which he is adding maybe 1 billion rows per month,...

But full of recursive awesomeness!!!

Great code.

mohd.nizamuddin (4/12/2010)

---

Nice Article Paul. It is very well expalined with example.

I have a doubt, since the UDTF would get executed as many times as the row count of primary resultset...

Christian Buettner-167247 (4/12/2010)

---

Me want the banana *whingingabouttheexplanation*! 😀

No results returned, as an infinite loop...