Last post Feb 08, 2011 04:03 PM by peterthegreat
Feb 08, 2011 02:09 PM|peterthegreat|LINK
I have a select statement in a stored procedure and want to be able to retrieve the key column value (PRODUCTID)and return it as Output when Select statement is executed on input Parameter (NAME).
In addition, return two further output values (COST,TOTAL).
note the grid control expects to receive all values at once! so i need to get out these values at the same instance of execution.
Feb 08, 2011 03:28 PM|suthish nair|LINK
using sql joins
Feb 08, 2011 04:03 PM|peterthegreat|LINK
have you an example for one from the same table