Hallo Gemeinde,
wir haben ein Problem wenn wir aus SQL hearus ein XML generieren wollen. Ich hoffe es ist o.k. wenn die Kollegin weiter unten ihre Frage in englisdch stellt. 1. We have different reports like getting all articles of one particular catalog. Then we have to filter them and sort them and generate different output like flat recordset and XML. In this senerio we need to use temporary table for storing the final set of records . We found that it takes 2-4 seconds to generate XML output for one single article. We also found that it slower because of using temporary table. That is why the stored procedure is recompiling at each run. I have attached the source code of that stored procedure which generates the XML output with this . Could you please give some idea to improve the performance. PS: W�rde es Sinn machen Euch die Sproc zu schicken? mit freundlichen Gr��en Georg XXXIX. Mouratidis Web Application Developer Heiler|Software AG Mittlerer Pfad 9 D-70499 Stuttgart Tel: 0711-139 84-610 Fax: 0711-866 63 01 Email: [EMAIL PROTECTED] Connecting Buyer and Supplier http://www.heiler.com | [aspdedatabase] als [email protected] subscribed | http://www.aspgerman.com/archiv/aspdedatabase/ = Listenarchiv | Sie k�nnen sich unter folgender URL an- und abmelden: | http://www.aspgerman.com/aspgerman/listen/anmelden/aspdedatabase.asp
