Do SQL Server Views take Parameters???

[code frog 0]

Can SQL Server views be constructed to take parameters?

Some assembly required. Code-frog System Architects, Inc.

[Chris Meech]

The short answer is no. But this link[^] says it much better. :) Chris Meech I am Canadian. [heard in a local bar] Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer] Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]

[rmhewa]

As far as I know you cant pass parameters to a view. As an alternative what you can do is create a user defined function in sql server (2000 and later) where you can pass parameters to the function,do what ever the process or selections you want and then return a table from the function. Rohitha M.Hewa Senior IT Executive Naturub Group of Companies - Sri Lanka