Duration: 17:58 min
Summary: In this video, we will discuss temporary tables. We can create temp tables local to the session, and temp tables that are global. We use one # for the first type of tables and ## for the second. Temp tables are very handy to store computation extensive statements to be used in multiple places in a proc. I will illustrate how to create each kind of temp tables and how and when we are able to use them.