SQL Temp Tables

Have you ever wanted to know how to write T-SQL? This new series covers how to go from having little to no knowledge of T-SQL to a PRO in no time! Austin covers some of the best practices for working with SQL Temp Tables. How to leverage them with CRUD operations as well as use them to filter results with JOINs.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Austin30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️TH-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@higiniofuentes2551]

Thank you for this very useful video!

[@no_name5002]

In what situations is it better to use Temp Tables over CTEs or vice versa?

[@austinlibal]

Thanks for your question!
Temp Tables should be used over CTEs when you have some sort of multi-step operation, or you need to reuse the data multiple times throughout a larger query since the results are temporarily stored as opposed to only existing for one single use. CTEs should be used for recursive queries or single-use queries or if you do not have the permission to create temporary tables.

[@higiniofuentes2551]

@@austinlibal Why I could not have the permission to create a temp table?