Temp Tables 1

[WJProctor]

HI there, it is accpetable to create tempary tables at run time which are created and deleted by the application, as and when needed. I thought i could do it because it would save having a read through an array of loaded data, and would speed up searches, but dont know if it is advisable. Hope you can help out.

Regards

James Proctor

http://www.ebmis.co.uk

 

[mrdenny]

Yes. That is why they are there.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[nigelrivett]

If you mean temp tables i.e. #... then yes.
If you mean permanent tables that are used as temp tables then no.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.