08-07-2008, 03:36 PM
|
#1 (permalink)
|
New Member
Join Date: Aug 2008 Model: 8100 PIN: N/A Carrier: Vodafone
Posts: 5
Post Thanks: 0 Thanked 0 Times in 0 Posts
| MS SQL stored procedures in MDS App Please Login to Remove! Hi All
Due to the restrictions of not been able to use the percent operator in the Database Operation Designer I have created a stored procedure. When I add the SQL DB as a data source the stored procedure is picked up and the input field recognized. However the output of the procedure isn't recognized and no fields are returned with the response message. Is there any way to get MDS Studio to recognized the output response of the procedure? I have even tried the OUTPUT command in SQL but with no joy. |
Offline
| |