001 - SELECT SET FROM DISTINCT WITH TIES - Microsoft Cert 70-761 (Querying TSQL)

Description:
*********************
Minute Markers
*********************
2:50 - Aliases
4:42 - Name Parts
5:48 - Selecting with Aliases
6:38 - Selecting Data (Not Assigning)
7:52 - DECLARE and Assign
9:18 - Assign using SELECT and SET
10:23 - Assigning variables from tables (single record returns, multi record returns, error, etc)
14:48 - Persistence Demo (SET vs SELECT and how SELECT keeps values)
18:30 - Selecting from tables
19:10 - Implicit Join
20:46 - Stuff without using STUFF() (including how it breaks with DISTINCT)
23:20 - SELECT Hints (DISTINCT, TOP, WITH TIES)
28:54 - SELECT and SCALAR Functions / TABLE VALUED Functions


*********************
File Downloads
*********************
Create Script:
https://www.elricsims.com/youtube_downloads/70761/001_CREATE_SCRIPTS.sql

Tutorial Script:
https://www.elricsims.com/youtube_downloads/70761/001_TUTORIAL_SCRIPTS.sql

*********************
Additional Comments
*********************
23:20 - I said DISTINCT fires BEFORE order by (even though I just demoed the opposite)… totally not what I meant =/. Mentally thinking ORDER BY / Sorting fires before DISTINCT…. But… Welcome to my brain. Apologies.


Note: I use DevArt's SQL complete tool to speed up my production. I highly recommend it. I like it so much that I asked DevArt if I could be an affiliate. Yes, I asked them. They were kind enough to say yes, So here is my link:

https://secure.2checkout.com/order/cart.php?PRODS=5023603&QTY=1&AFFILIATE=114121