Is it possible to pass parameters to a view???

[herb8]

The heading says it all... just need to know yes or no.

Thanks, Matt

 

[redlam]

Not that I know of... can you use a stored procedure instead?

 

[herb8]

I could not use a stored procedure for this because I need the entire recordset back to use. The only way I know how to do this would be using output's and therefore could only bring back a single row.

 

[balves]

A stored procedure can return a recordset. The last SELECT ... in a stored procedure is a recordset.