executing stored procedure issue

[svisveswaraiya]

Hi,

I wrote a stored procedure and tried to execute in thingworx using execute command and kept the type as sql query but I am getting error and when I execute it am getting result set as Nan. Below is the command I wrote:

execute Modelwise_RollOff_QaOk @typeName = [[Type]] ,@shiftName = [[ShiftName]],@model = [[Model]];

Please provide some help.

Thanks,

V shalini.

[supandey]

Hi @svisveswaraiya what exactly does this procedure do? Also could you share what sort of output does this service provide?