Only one instruction executed an MSSQL store procedure
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?