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
>
>

Navigation is not working correctly when I apply security on RS.

The site is working, all of the reports run, but all of the navigation drops
the https navigation to http links which will not render the application.
Does anyone know where I missed the https to configure as a secure
application?This is everything in my navigation
Home | My Subscriptions | Site Settings | Help
and if I go to the subfolders the home link for the subfolders does it too..
Any help will be nice!!
"Matthew" wrote:
> The site is working, all of the reports run, but all of the navigation drops
> the https navigation to http links which will not render the application.
> Does anyone know where I missed the https to configure as a secure
> application?
>