Hi All.
I have a problem with calling a stored procedure on my MSSQL server, I have tested the following sql query in studio express, and it works very well.
declare @RetMacNr varchar(20)
Exec GetMacNr @RetMacNr = @RetMacNr output, @boardSN = '1234'
select @RetMacNr as nbr
The problem is that after I have executed the step "open SQL statement", then the number of records returned is -1. So no errors, if I try to remove one of the first 2 lines then the step is failing, so it doesn't seems to be a problem with the step can't handle more sql lines in one step.
Why will the step dont return the output variable..... it should....
I can see on the forum that you also can call a stored procedure with SQL action step.....
Can anybody help me with my problem, or can anybody help me with an example of how I can call a stored procedure with the SQL action step.....
Damn the manual is bad.... no help at all on these steps..
/Thomas