calvo (9/6/2011)

---

You cannot create a parameterized view in SQL Server. A Table-Valued Function (TVF) would probably be your best bet.

something like this,

CREATE FUNCTION dbo.fxnExample (@Parameter1 int)

RETURNS...

winston Smith (9/6/2011)

---

Connections are expensive to create in sql server and this is why sql server uses Connection Pooling by default.

Connections that are not in use are put into a...