SQLTeam.com | Weblogs | Forums

Temp Table

Hi Friends,

I was just wondering what different problems do business often try to solve using sql statements where it oftentimes helps to use a temp table. Thanks !

Personally Inuse temp tables when I dont want to blindly join to a huge table. By using a temp table I get a subset of the data. But it could be a double edged sword if you dont do it properly