Bonus: Numbers Tables (18m)
Numbers tables, also known as tally tables or date tables, are just a simple table with just what you think: a buncha numbers. They’re really useful when you need to build dynamic SQL fast – or build something truly terrible, as we shall demonstrate with a query that kills your server. Demo script: Transact-SQL /*…
