SDSQLUG.ORG

philhelmer.com

Common Table Expressions | SQL on the Brain

http://www.philhelmer.com/tag/common-table-expressions

SQL on the Brain. Tag Archives: Common Table Expressions. Composable DML (OUTPUT clause) inside of a T-SQL Common Table Expression (CTE). June 23, 2012. Disclaimer: the following was tested on SQL Server 2008R2. So, the basic syntax would look like this:. OUTPUT inserted.ID,. Deleted.Amount AS OldAmount,. Inserted.Amount AS NewAmount. When you run such a statement, a row is inserted into AuditTable. For each row updated in MyTable. If you make that a sub-query, however, you can do something like this:.

philhelmer.com

SQL Server | SQL on the Brain

http://www.philhelmer.com/tag/sql-server

SQL on the Brain. Tag Archives: SQL Server. PASS Summit Free Pre-Cons. September 18, 2015. Are you going to Seattle for the PASS Summit. These are listed in chronological order. If there are any other events not shown here, please let me know. Red Gate SQL in the City. Monday, Oct. 26 – Hyatt at Olive 8. You can choose whichever sessions you want to attend. They will also be featuring a hands-on lab where you can try their products out. SQL Solutions Group Summit Free-Con. Small fee for lunch. Click to p...

mickeystuewe.com

2013 Speaking Engagements | Mickey's T-SQL Ponderings

http://mickeystuewe.com/2013-speaking-engagements

Mickey's T-SQL Ponderings. Nov 21, 2013 – Inland Empire SQL User Group, CA. Oct 19, 2013 –. SQLSaturday #237 – Charlotte BI Edition, NC. Oct 14, 2013 – SQL in the city – Charlotte, NC. Oct 9, 2012 –. SQL in the City – Pasadena, CA. Sep 30 to Oct 4, 2013 – Dev Connections – Las Vegas, NV. Sep 21, 2013 – SQLSaturday #249 – San Diego, CA. Jul 13, 2013 – SQLSaturday #214 – Louisville, KY. Jun 20, 2013 – Inland Empire SQL User Group. Jun 12, 2013 – South Florida Business Intelligence User Group. Top Posts and...

sharemypoint.wordpress.com

Southern California .NET user groups | SharePoint, ASP.NET and more

https://sharemypoint.wordpress.com/2013/11/08/southern-california-net-user-groups

SharePoint, ASP.NET and more. My development tips and tricks. Injecting Values for Default MVC Model Binding. Crosstab Query (3) →. Southern California .NET user groups. November 8, 2013. Master Calendar of many developer user groups in the OC and in San Diego http:/ www.socaldotnet.org/. V Next Orange County http:/ www.meetup.com/vNext-OrangeCounty/. XPSoCal (Agile) http:/ tech.groups.yahoo.com/group/xpsocal/. Orange County .NET User Group http:/ www.ocdotnet.org. LA Coding Dojo (Live coding practices) ...

philhelmer.com

Transact-SQL | SQL on the Brain

http://www.philhelmer.com/tag/transact-sql

SQL on the Brain. Test Data Builders at SQL Saturday Las Vegas (Sept 12). September 10, 2015. At SQL Saturday Las Vegas. Sept 12, 2015), I’ll be presenting about test data builders. I’ve attached the slide deck and demo files to this post for your convenience. They’re also available directly from the SQL Saturday site, just visit my session summary. Building Your Way to Better Database Testing – Phil Helmer – SQL Saturday LV 2015 #436.zip. Click to email this to a friend (Opens in new window). Often in l...

philhelmer.com

teaching | SQL on the Brain

http://www.philhelmer.com/category/teaching

SQL on the Brain. PASS Summit Free Pre-Cons. September 18, 2015. Are you going to Seattle for the PASS Summit. These are listed in chronological order. If there are any other events not shown here, please let me know. Red Gate SQL in the City. Monday, Oct. 26 – Hyatt at Olive 8. You can choose whichever sessions you want to attend. They will also be featuring a hands-on lab where you can try their products out. SQL Solutions Group Summit Free-Con. Tuesday, October 27 – Hyatt Place Seattle/Downtown. Click...

philhelmer.com

Editorial | SQL on the Brain

http://www.philhelmer.com/category/editorial

SQL on the Brain. Transact-SQL PIVOT & UNPIVOT redux. April 22, 2011. The presentation went well, although it did go 2 minutes over. It’s hard to top the feeling you get when the audience is engaged and asking a lot of great questions. Thank you SD SQL PASS chapter and especially all of you who came out on a work night to listen to me go on for. 17 minutes. It’s ok, we all know you really showed up for the PowerPivot demo. Great job Lakshmi. As promised, the slide deck and scripts. April 21, 2011. I&#821...