SQL Every possible combination of two tables (Cross Apply)

preview_player
Показать описание
In this video I show you how to create a SQL view of every possible combination of years and week numbers. I use a modern approach, which used to be handled via a cross apply but instead we use a from statement from multiple tables and create a view based on this for easy querying in the future. #sqlserver #sql #sqltips
  1. Artfull Coder
Рекомендации по теме
Oracle SQL Practical 0:06:39

Oracle SQL Practical question | Oracle SQL to print the all possible combination of numbers

SQL : All 0:01:29

SQL : All possible combinations unpivoted

Databases: SQL query 0:02:02

Databases: SQL query for all combinations without repetition

Master SQL CUBE 0:00:58

Master SQL CUBE in 1 Minutes ⏱️ | Unlock Advanced Summary Reports #oraclesql

Do you need 0:00:51

Do you need to learn SQL if you can do everything in Python? #Python #dataanalysis #SQL

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

SQL Query | 0:05:08

SQL Query | How to find most frequently purchased together items

HOW TO JOIN 0:04:05

HOW TO JOIN 3 OR MORE TABLES IN SQL | TWO WAYS

SQL Query | 0:06:55

SQL Query | How to generate match schedule for list of countries | Match one row with all other rows

Understanding Cross Joins 0:00:52

Understanding Cross Joins or Cartesian Products in SQL

Any operator in 0:04:45

Any operator in SQL | Multi Row Subqueries | SQL Tutorial

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

SQL Trick | 0:00:28

SQL Trick | Match single character | Pattern Matching | Like #sqltips

SQL Trick | 0:00:38

SQL Trick | Triple Replace | Reduce Multiple Spaces to Single Space

5 Basic Sql 0:08:07

5 Basic Sql Joins - Every data beginner should know !

Complex SQL Problem 0:16:07

Complex SQL Problem Asked in a Fintech Startup | SQL For Data Analytics

Rollup, Cube and 0:09:11

Rollup, Cube and Grouping Sets in SQL | Advanced SQL Tutorial | Beyond Group By

Advanced Aggregate Functions 0:06:00

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

#SQL - Interview 0:06:57

#SQL - Interview Question- SQL to pull unique record after combination of column #SELFJOIN

How to Think 2:00:59

How to Think Like the SQL Server: All-Demo Edition

Mastering SQL String 0:00:50

Mastering SQL String Manipulation with Regex_split_to_table() function

#sql Interview question 0:14:46

#sql Interview question Schedule cricket match between teams and generate points table using SQL

T-SQL Challenge: Quickly 0:50:08

T-SQL Challenge: Quickly Finding Rows with the Largest Strings

Tally Tables for 0:13:45

Tally Tables for Fast Transact-SQL Solutions to Complex Problems