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...

Trouble Shooter (4/12/2010)

---

select * from tempdb.dbo.sysobjects where name=<Table Name>"

That statement will check the existance of temp table in temp database if it is exists in temp db it will not...