Has anyone had experience using SQL stored procedures to integrate with VMP?
Specifically I am attempting to return a value from a SQL table using a EXECUTE on a stored procedure but am not having any luck actually retrieving the data using the "Database Get Data" data after the "Database Execute".
I assume that the reason is because I have nothing in the Database Execute to represent the data that is being returned by the OUTPUT of the variable. I am using:
EXECUTE usp_StoredProc $CP1,$CP2,NULL
Can anyone tell me what I am missing from the above command to either get the result of "@_CodeGenerated nvarchar(20) OUTPUT" in my stored proc? I have tried things such as $CP0=@CodeGenerated and such without success.
Kyle Holladay
ACA-I, ACA Call Center, ACS-I, ACS-M, TIA-CTP, MCP/MCTS Exchange 2007
ACE Implement: IP Office
"If it worked the way it should you wouldn't need me
Specifically I am attempting to return a value from a SQL table using a EXECUTE on a stored procedure but am not having any luck actually retrieving the data using the "Database Get Data" data after the "Database Execute".
I assume that the reason is because I have nothing in the Database Execute to represent the data that is being returned by the OUTPUT of the variable. I am using:
EXECUTE usp_StoredProc $CP1,$CP2,NULL
Can anyone tell me what I am missing from the above command to either get the result of "@_CodeGenerated nvarchar(20) OUTPUT" in my stored proc? I have tried things such as $CP0=@CodeGenerated and such without success.
Kyle Holladay
ACA-I, ACA Call Center, ACS-I, ACS-M, TIA-CTP, MCP/MCTS Exchange 2007
ACE Implement: IP Office
"If it worked the way it should you wouldn't need me