Hi James, I do not think that SQL aggregate functions work for temp tables. I read that it does not work for set base operations (insert, update and delete). Set base operations are always down graded for all temp tables. This is because temp tables use the windows file system unlike SQL database requests that are passed to a server service that process the request and send back the result. The file system is a direct call to the data on disk without a middle tier service to enhance the performance.
Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. ________________________________ From: James Flavell <djf1...@gmail.com> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Fri, July 30, 2010 11:15:45 PM Subject: [Axapta-Knowledge-Village] RE: Temp tables Sorry I also meant to ask if I have a temp table and use SQL commands like sum and count is there still any benefits or actually this is the same as using a while select? Thanks J From:James Flavell [mailto:djf1994@ gmail.com] Sent: 31 July 2010 13:05 To: 'Axapta-Knowledge- vill...@yahoogro ups.com' Subject: Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% … I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James