Would anyone know of a fix to this problem? I have a small stored proc that can get called many times a second. The basics of this are..
The problem is that if 2 of these SPs are running at the same time then I get the following error...
Table 'TEMP_BLAHH_BLAHH' already exists
I am used to Sybase there the temp tables are totally unique to the SP's transaction.
Does anyone know of a workaround/solution to this 'cos I have no idea?
Thanks
Code:
BEGIN CREATE TEMPORARY TABLE TEMP_BLAHH_BLAHH ( BLAHH_ID int ) ; -- A BIT OF WORK END $$
Table 'TEMP_BLAHH_BLAHH' already exists
I am used to Sybase there the temp tables are totally unique to the SP's transaction.
Does anyone know of a workaround/solution to this 'cos I have no idea?
Thanks
Comment