PKta8`n"DEMOS/Aggs - Cumulative Totals.sqlW[O0~phP4ƴ׵MM\ؙPw{ L%cws}^| {vlQؖmZ-p Dr| &L"bzFygf =ODŽmLn?m G! jhp/J/7RLF1 LTτo[2ih96.>A SqkhbJ+@pz|F%&g,= iY}5F|)|>{vn?KIѬB4 #h)ypJngeT+W5ntl++VzP=Cuؖ>0YJD&tŴ5 {غ%T)CBD:")7+OPmK  %زJ3fNFO┡A(j5zVYn =k:ћANE#C @Ap!^*) P*7$etXW3ߓKdMMgIYXm$|Ke!7b%̪AtUx&*17C00RjA&?f;K+$c({nL/*8E7mc|sLG>pě H!DXi #/T( fk^n&N)\Q j@ǩtײ{r;N*;*-q|Oi&6w/}8Nm|<.» j.z|J9־$.j{w%Z}eV[yk%OQgġiS!/unRմͪg]}QtPKv{a8z~S>z !DEMOS/Aggs - OVER v Sub-Query.sqlUM0#eYJv+ZB{E&16YSʿIH RN=Tkcϛfd0{x|D`oRՠ09aotwxΥI$U>f,?\afiEK*l'4r+V K/De>i>5B{m2Bm9>LDΕ_];zֆK#.b iF 11o*fmUBea.Ȥ=#V\h_t(`X'GdmcH `xr:Ƥb-@d0; B,$s(lpz_n-nk}KLg 4) )7RjV`g,={gH7Q u1[{9I&1uÁ?R{){qwxQZ7*=K0ٴ@Xoks(% ~j"F \^U{R; _+nό{zcIN?qkAW?:EˆqGDoM517=R׀EKh .zۡwPK@{a8˒-DEMOS/Aggs - Running Totals.sqlZ[s6~׌+;ƻJRN-y)BCZsP(R-/@\s}5>oFݺUV*˫(R]%9V^&&g)ޤL '/'g1]yٯ]<$p0:[ Y`=4ʀX0-$͵v19m`iJF,z_*/x7[5B;G(xvI<2HBjB`W,uOz5}}~O54qo*(9< ?h[gJh4Oyb/82B $\'SG|YаM^6l^#qQ '潈y9b/Mۃ~#_?xۭ=+* B=קDU(tZe imw 6Cu&r6V*7mƎj3sTL3}Pl"z - 9<*lHW17S%ڼjBF)o3/IvuiT"hiWeYM暜)V0|O $2m`9 .ޞ+#n0/gl2lI:Av(gj5ה-+p;PB/y@ZUx%2\XV`Aɓ'Mk8ڔBt~)Ak%% }3CxqM -aW+ퟷF؈0::B< ǪEv!ᒠ#3 |׽[Ƶ]FǷIBtQќ%+-6rk%~4F,1B>%vap͊stoC ??>^w 0+vFeeX2wd Cg.&yH4"+:56 u$Ֆ\SZ1i^.Y M7W؁``_z$q}Oϯ~}uzXV;~<-lu[[,yV1I9"f%vS`F>L<2Arӻ} 7j9͡l! GqkKMs> g LA'$8E X#o7+˥_^eۦ$wPRwmIcA7ON({̵W4ƖCS̊T:(NB ܏W^[{fYRAkO59%d=LJTF7 c޸,>is!wj_oh쏭p쏳plG Buz5N{c˰vA͏/vAgdP:fQUӏoO T=ַ.}%XKYY-캣FǼrX~UOI˗?D@~'PQQv Gv(su4T0kw߯st'0`.$B/ Ġ^$dT'~ ^N*D,0D *aòrzBI<Mo+G.K"G2qmv?;^N׿e2=2m>n Qo$yf4}%@4Ae8\Aj(VkTjsy=HO_-#*'iGw-KgdN;= Oz1~?}PK؎W8&TDEMOS/CTE Recursion.sqlU=o0-@6K6E4u"CghlHߗ$Zi\ 㽧w{/ZV\{߃%P@hGLMdBfAxİF`J%+SK\>iP9&0?A ?Mժ5C.6_c4!E!Am}*&'00I d}ITc jԩ 'ELE  L`ʰuaEQ];23gk޼UQ+IjJ©(N>sk9[ϒ*qCӕyj+ݟw#PzP{TlWf4 7DE2eNe\ p$dž0;!b0a't]~qJ%5Pzjj+*԰U:8ooCfk~RuSENgVpF}ʵ; {ZojԤw"|&t37!EdNM6zzaۯ'Uoau ЗѸBh?[o "M/b`|PKd8#l>DEMOS/DEMOS.sqlsuoZoTUm,P(BC%}P(51E2З,tfi Ht?bʭ+c\hƅэKuAL4J{;Νias=|sw'xMÕZ Tb+UT/pYsk;ug`?66I$7/A I,I1_gֲPGw lCwrU΁4Z!5#_HA,*4ކzs嚜Ye)d&4~3kL{ Ft b2MVgBpwOۧ1yegvgͽ1DABD^2x\ugβ ǎ8s=t姰sXcrSȠf&OLk`[x!;^.֘,|)Jsx>̈́p_->*cx?ge))λ4\XKjV%8R߽_̥?%"X Y.K҈irsُ]NaEu:2;"u{?^.d˟ ٚ-EYH ˊ_l4ưC4|O^vG:"c[}`{]]y~:CWLVVHSH^'1JlAA+eAS)5GyUs+H> aN^`Rxop ɻrȡꑲa-zdRuJ]Uk{e\RȍcXB7I>qrqzcZwoiC3fb/}wc,`$xR&" o(_<+y۴G!%Fas[Hzuh}Ri!s Iゅ`j1:KIyM$ϵkA J"$@Y2Ήu0uxPƵ _J~}R=. w6I۰ٛ3[[fqc4wr~ކ쟿 5WfM_1XaJ}cE>bςm݂!vU:AFb>VVh: ڵ"AoZZ}IT_"mcϩ-~f[Rl[F ɔƂTX* XQg  [ 8FTdF>7x6v,e,yv4tHsQe_m4*Vf-K#rr֟;Zh<"w@5 ~{o?-smZ#uG+cE w*P3b-fr1Oe\G'd³o߳dw57y9zeySfjo;}=~^ZS蟤 /AW cx?Wr?qzQoTrџT?k/Rfc=X?xeڀTNyT׏?Zm[u/UFPK@W8}`V=DEMOS/DEMOS.ssmsslnUOKN0\ג`yU ذd1[;YU= pAb̼y_l^3al-R` Ic Imh&)Ż7}D$5$I22'IXZԷߠ;}Vxu!Cx}͆ӊa Ҫ&ESp"d,bT\0]!nZ`,_^0轞xx0:|T"r1O PKc]8LDEMOS/DEMOS.ssmssqlprojMo0+r]$PBJ&mw^Lb[Nm̌gy4fhLN6μ?\= '<V$jN=5FZ'M˚L&I$*۶cؤ\iCb, 195ZN7 kMb5Í+""sK9d(o L ,eJ}-lbCEهc3?oR J,$ne\ ZvS:˶ZsӂݸlTx =ֳrEAUyGk=QBiZ3+TSZ뱳DsU($LdcHv!С`^Wh?!!PMbIz20^R(1x9JGN#*R"ɚz|: %lIJBedEá.8e@hTI5+%BIrYMGpÆJdwhbW~5 Zc0hصqw$ ܷٷp2vEɵfs}~hoΔtD6H&rN(:MDSoOq0>6q49B_Ù_s-=* q܇GK G]؟҂}|L6lkSq,x4DeW#mwڷs;T1Ἷ8V>>pHq7G06{5yyFf(è~n~n^oG-e+-c qr>C)?t*dc7a7LǮؖ_/3;zS#nJL B2dʓk% 3<OQ_Yر6vt?KrQɆ @xoCr f[Ŵ㭟;w/)yUUl7 rog:/SYAgxӰJUb7/H d2U l-;vcԢ5P I( #Z B>֕Z5PAig eĬMh30d?*mVT9k_GZ>6aXXVAKKoRن-H3qUL Xݘl:,8,- (d 4M$"߽L“[ߒֲd+Xtd{kx0ev{br au`Zےi77 YvR1dRNMGKM#-(u]QWE'^2ږ ]sAQ )}T M5uÚ]-oW R:VбVw.աuA,$PN\]ĉgh"AiJRY-`03PMNܨ3 2oM?`V`kDSI9SQhY[gw~\ȶ-\?*6a2;Uy4zrPKma8}N+ B)DEMOS/Intro - Common Table Expression.sqlWs8~' 5)Ц^/\Qȁs{[[$mL \:UT?j 8#o2E<69+ɕDNZ- B&VWY)6oNf\!<Cn,X싺ޮxYh>BT`wI\ MQV{c-͆d{a2G7.I {1 pݛxo0?F('H)B:<ЪVqAN5٘j!U>ǸѼѴ\H|_s}QC(yxsFiR>K:EU^HE Λ^֪nDTaS&( Ŧ^PN9~4A?aV|xE+! aՊn(l֐@/V8g`đDo`-%O5_?B3z^Nߜޅ[9ICۇm8vﻀ}_s7ܩ_9{0D;e?xxb!iF-`-YAS VM2Wq5`)MOeMdvCX;N:BPaC, f5syLg GӾ0G]TӁ6id|sy}[Ԟpy6 +h-Wת ]Cvg:  mk'v œ'Rc7b59rCE$݁K Ȅbӛ"`)d;&%NݤfD$ $(g$̪*I,`[;ɞ}ɽ7S\_<ks0V`$=TR@ +-3:Ҳ9(c E dv_6ơ:L °coH8;8@/1dQnjqGV@: CH4ֽ S) `IMH'͌;d]M(]PFulY =KV*jbNl+ϡ ~̸Էؖ !v2 }еĮ@lifeuZ[GE$L(u0,uBFw4'XH9us]׌B9Հ ~J;v(߲Sʀ`)WkP]PTTv J W ^=˩;֗&iD b́l*<. JTE^XVa ׍~¨bt`I1 e15{j/G]?)] =~}`'}9̒9\QHm#ۄώ›jS\-kk{?g]! ѕ(Ƽg8%4>2Չ JR4u:5_QYt;0r#8L<sz9;8S0۱"ܽ0z In(]`-W c̒RW8:6%ۍvkk%_a^;FvJ. ̷H %eГT7_R-b, Yɓ5nB8hm.HiQE2iCPiṕHuR-a \d+9aTp w*IƂP~/72V3LYRh-֨![B9R')[`4Ka,8DB;DJ֬t.r~ZHḫGi=;Vky5Ig_p(wR߈1LHAlA/"΢P>-.:#tF6Gsv~)ù ! n7u;x=11Sv<$Jƚ@ ݆eޡ>7 {gcX\, {H3m[vDK j# =I^1..F[1%!ڤ80]|.1:F O_^">W9ʕѓT^؇e'1.!jaJL⢯M(OaQ+ÄYan$|wEǮ+ yuZP!j׶*KeQ|d?!Vi(POUi F^Vս/#v])pE&*rg2KuV\Cs1|ė/:[?O2śnoڎ-en&PK&qa8s}3 0DEMOS/Intro - Temp Table and Table Variables.sqlVKo@#ꁇHxCE!jQˁ$QOhuw!̮b9j}373;ܬS.K'J3 E/L wF~x0b2O0˝p4pr%jKD i˥p0ל'ZCStȻIp?t,09TIdPB֑4g?E1ZRYiy;V5$ZhD\A$9@Ic5rzy1L:J=U:jZ#grt3l` ( 1<Jo!yAyL^8x6ewbG2!טatjՊ[퟉rVIpc!dyЕ 0*tw)5\ME2&k Tsb y():8̸]q.喧svFlDYao÷4cq4z-Saahe |}B,oYsi.8`B[V+2gՌ :<$_c9ih49K)C5q&`bbn(};gaJkϻ{m)ߦ+,V8m5w*+ k-I,B>p묻>€!?zMǙr6 uHh78,#P/޴ui(˟*24)s$z~( ]!rSуȎ*BQŚ*N^#1!0o]PfO ]hurq=;`_99i!Լ2PKk2DEMOS/SQLQuery1.sqlPKYa8!;<DEMOS/UNION.sqlKK@k*ƅH,l0f&΄۟j-f|&xGqWHa /dD yldok m%Z'*Cuys@gC- xt*[3Cp[TԴ- FYTe-wOyEuza4Sgv]yPK{a8P(DEMOS/UsingGlobalTempTables.sqlmRJ@}}HmAAPMUBI;j).gfΜk 4$["\1)a mR^ "P@Bx-pE{A+:WDMEMi¦eVV%ZJeуpM!H&$)T tic7MԎўJ5gotF0{uw9LkN}n>߯w{E2&ŊɵݠdkfSڬ@ĜWfWjI('ӖaA '2 wנӔ*s>p4+EEJk?҂Ӧ7L):8^/PKta8`n"DEMOS/Aggs - Cumulative Totals.sqlPKv{a8z~S>z !DEMOS/Aggs - OVER v Sub-Query.sqlPK@{a8˒-+DEMOS/Aggs - Running Totals.sqlPK؎W8&T$DEMOS/CTE Recursion.sqlPKd8#l>"DEMOS/DEMOS.sqlsuoPK@W8}`V=DEMOS/DEMOS.ssmsslnPKc]8LDEMOS/DEMOS.ssmssqlprojPKX8x  DEMOS/Example Schema Setup.sqlPKma8}N+ B)\$DEMOS/Intro - Common Table Expression.sqlPK_a8ca8 *DEMOS/Intro - Derived Table.sqlPK&qa8s}3 0.DEMOS/Intro - Temp Table and Table Variables.sqlPKk2;2DEMOS/SQLQuery1.sqlPKYa8!;<l2DEMOS/UNION.sqlPK{a8P(3DEMOS/UsingGlobalTempTables.sqlPK5