My Mortgage 😉

Inversion

Subvert

siggemannen (10/10/2014)

---

Sean Lange (10/10/2014)

---

Consider closely what this is doing. The return from your function is NOT an nvarchar(max). It returns a table with a single column that you are then...

Matt Miller (#4) (10/10/2014)

---

Sean Lange (10/10/2014)

---

Consider closely what this is doing. The return from your function is NOT an nvarchar(max). It returns a table with a single column that you...

LOL. The original link seems to be working again now anyway. 😀

Here is the google cached version. This should work for you.

http://webcache.googleusercontent.com/search?q=cache:FnRGE_r0_EIJ:sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/+&cd=1&hl=en&ct=clnk&gl=us

Oh crap. Gail's site is down. That is the correct link. Let me...

You need to read this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It sounds like this exactly the kind of query you are doing here and performance can really stink if you don't do these things...

Consider closely what this is doing. The return from your function is NOT an nvarchar(max). It returns a table with a single column that you are then trying to pass...

I am glad Luis was able to help you with you query but I have to ask. Why are you using the real datatype for nearly every column? This looks...

acid

For what it is worth I PM'd the uber spammer and asked if they would stop posting useless comments to old posts. I said that I would love to see...

Here is this with some applied formatting so we can read it. You can maintain formatting on this site by using the IFCode shortcuts on the left side when posting.

UPDATE...

Edition