need example of sproc

looking for an example of how to correctly build up a dynamic where clause
based upon input parametersHi,
See the link for the detailed article on dynamic sql.
http://www.microsoft.com/technet/pr...n/spltmirr.mspx
Thanks
Hari
SQL Server MVP
"TJS" <nospam@.here.com> wrote in message
news:e2Ixgr6aFHA.1660@.tk2msftngp13.phx.gbl...
> looking for an example of how to correctly build up a dynamic where clause
> based upon input parameters
>|||WHERE name = ' + @.name +N'
"TJS" wrote:

> looking for an example of how to correctly build up a dynamic where clause
> based upon input parameters
>
>