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 !
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