From Excel to SQL - Final Notes

This is the last video in the 'From Excel to SQL' series! Thank you for working your way through these, I really hope that you've found them helpful. For more Microsoft SQL Server videos, I recommend the @DataWithBert channel: - https://www.youtube.com/@DataWithBert --------------------------------------------------- The "template" code that I flashed up on the screen is: ``` WITH CommonTableExpression AS (...) SELECT DISTINCT TOP ... -- *, CAST(SomeNumber AS VARCHAR) AS SomeText, CASE WHEN ... THEN 1 + 2 ELSE 1.0 * 3 / 4 END, FORMAT(..., '...'), AGGREGATE_FUNCTION(), WINDOW_FUNCTION() OVER ( PARTITION BY ... ORDER BY ... ROWS ... PRECEDING ) FROM CommonTableExpression INNER JOIN ... AS JoinedTable1 ON ... LEFT JOIN ... AS JoinedTable2 ON ... WHERE ... AND ... GROUP BY ROLLUP(...) HAVING ... ORDER BY ... UNION SELECT ... ``` --------------------------------------------------- This is part of the From Excel to SQL playlist, available at: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rhnVPQ_Tj3Q-CI0rGn_uiD Check out the previous video at: - https://youtu.be/8e4mQfEDJDk