John Hick-456673 (4/17/2015)

---

spaghettidba (4/17/2015)

---

craig 81366 (4/18/2013)

---

John Hick-456673 (4/18/2013)

---

I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.

I'm going to be blunt here.

I find that extremely hard to believe.

+1

Dynamic SQL is difficult to beat in this case.

I would go as far as to say that suggesting this technique is a bad advice.

You are two years behind the eight-ball, there. But, thank you for playing. 😀