Designing Temporary Tables in SQL Server 2019 and Azure SQL
Temporary tables play important role in designing data and analytics solutions. These tables contain the output on temporary basis and dropped automatically at the end of execution. In this video, I am showing you the usage of local Temporary tables in Stored Procedure. We shall use it in our K Nearest Neighbor(kNN) based Recommendation system solution as well. However, you will get a good understanding of creating and using temporary table in this video.
I am generating data table from the stored procedure by passing the date range. the date information will remain in temporary table and will return from it at the end through simple select statement.
