use this: create table #mytmptable (<etc>) or the double ## as mentioned, if you want "perm" temporary tables for general working purposes, then I would rethink what your trying to do here. Perhaps post your thoughts for further discussion. Cheers Ck Chris Kempster www.chriskempster.com Author of "SQL Server 2k for the Oracle DBA"
2003-06-24
Try using the "between" Operator. For example in Pubs Database select * from pubs..sales where ord_date between '1994-09-13 00:00:00.000' and '1994-09-14 00:00:00.000'
2003-06-24
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers