all groups > sql server reporting services > january 2007 >
You're in the

sql server reporting services

group:

How to run multiple store procedures in SQL Reporting Service


How to run multiple store procedures in SQL Reporting Service Brian
1/14/2007 10:41:00 PM
sql server reporting services:
Can we run two store procedures in the Query String under the Dataset section
of SQL Reporting Service 2005? It seems like the Query String only allow one
store procedure. Ww want to use a separate store procedure to open a
symmetric key before we run the second store procedure to retrieve the
sensitive data.
Re: How to run multiple store procedures in SQL Reporting Service Jens
1/15/2007 2:18:04 AM
What about writing a thrid procedure calling the two others ?

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---
AddThis Social Bookmark Button