Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Only one instruction executed an MSSQL store procedure

Hello,

I created a DeskI report base on a MSSQL 2000 stored procedure. This procedure contains 2 SQL select statements, as in the following example:

begin
select object1 from table
----
----
select object2 from table as result
end

Nothing is returned in the report and the following message is shown: "aucune colonne ni donnée à extraire".

If I call the procedure in a MSSQL client, it works.

If I put only one select statement, it works.

If I put the same procedure in Sybase (with the 2 statements), it works.

Can someone help me?

Former Member
Not what you were looking for? View more on this topic or Ask a question