Subject Re: [firebird-support] Convert MSSQL Stored Procedure
Author Helen Borrie
At 12:15 AM 15/04/2005 +0000, you wrote:

>How can I convert and MS SQL SP that uses temoporary tables #temp to
>FireBird? Thanks!

It totally depends on what the temp table is being used for. For example,
if it is to generate a set to be returned to the client, you would write a
selectable stored procedure. If it is to create a set that some external
query has to read, you would create a "permanent temporary table" with
identifiers for the transaction ID and any other attributes of the set that
are needed to identify the set and have the SP insert its rows into that
table. There are other possibilities, too.

If none of this makes sense to you, how about providing some simplified
pseudocode that illustrates what your MSSQL procedure does? The closer we
can get to the problem, the closer you will get to a solution.