Dynamic search conditions in SQL Server

Browsing stackoverflow I found someone had linked up this excellent reference.

This is a handy reference for passing arrays into stored procedures.