/SQL/TSQL Code Snippet For Optimized Sales Query

TSQL Code Snippet For Optimized Sales Query

SELECT
    'Customer'[Company Name], 
    'Date'[Date], 
    'Product'[Color],
    SUM ( 'Sales'[Quantity] )
FROM 'Sales'
    LEFT OUTER JOIN 'Customer' ON 'Sales'[CustomerKey] = 'Customer'[CustomerKey]
    LEFT OUTER JOIN 'Date' ON 'Sales'[OrderDate] = 'Date'[Date]
    LEFT OUTER JOIN 'Product' ON 'Sales'[ProductKey] = 'Product'[ProductKey];

Source: sqlbi.com

Similar codes

-1 vote101 views2 answers
On delete set default sql server
SQL
10 votes144 views1 answer
Oracle view dependencies
SQL
0 vote149 views1 answer
Dapper run sql script with parameters
SQL
1 vote134 views1 answer
How to use a trigger to validate input data
SQL
6 votes150 views2 answers
Postgresql restore from dump
SQL
6 votes230 views2 answers
Non relational database
SQL
32 votes159 views6 answers
How to change column name in sql
SQL
0 vote144 views1 answer
How to convert DateTime to VarChar SQL
SQL
22 votes136 views2 answers
Mysql show all tables
SQL
0 vote154 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL