Calling MS-SQL stored procedure from ABAP

My SAP System had to call a stored procedure on a 3rd party MS-SQL database. As suggested by many blogs, I used DBCO to maintain the parameters of the database... (kind of a BASIS job, but anyway...)

Then found I could use the DBCursor mechanism to retrieve to a table... but my 3rd Party guy didn't want to use SELECT statements, he wanted to use a stored procedure.

Turns out you can use DBCursor to select from an Stored Procedure too...

We had to "qualify" the database name, pre-empting the stored procedure (see highlight)

data: ls_output type tty_output,                        "This bit will differ in each Stored Procedure,
      lt_output type TABLE of tty_output.         " so I have not put it in!! 

EXEC SQL.
  CONNECT TO 'CO11' AS 'V'
ENDEXEC.
EXEC SQL.
  SET CONNECTION 'V'
ENDEXEC.
EXEC SQL.
  open dbcursor for
  EXEC [DatabaseName].[dbo].[StoredProcedureName] 700, '2041', 'S1233124'
endexec.
DO.
  EXEC SQL.
    FETCH NEXT dbcursor INTO :ls_output-SerialNumber,
                             :ls_output-MACID
  ENDEXEC.
  IF sy-subrc = 0.
    APPEND ls_output to lt_output.
    clear ls_output.
    CONTINUE.
  else.
   exit.
endif.
enddo.