Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for SQL Saturday, the question came up of can you use an INSERT or UPDATE statement …
As part of my CTE research for my SQL Saturday presentation in Redmond in 2 weeks I decided to take on some classic computer science algorithms with CTE’s. Here is what I cam up with. Any math geek can tell …
The following example shows how to create a Tree Path with a Common Table Expression (CTE). First off what is a tree path? For this example I will be referring to the product categories at a camping and fitness store, …
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California. I have submitted 2 …
Sessions Submitted for SQL Saturday #120 Orange County CA Read more »
I am available to speak for your event. I am comfortable discussing all SQL Server topics such as SSRS, SQL Server, Transact-SQL, SQL Server Performance Tuning. If you are interested Contact Me. Previous Speaking Engagements SQL Saturday 172 in …
You can download my resume as a PDF. SteveStedmanResume.PDF The the most up to date work information visit my Linked In Profile: http://www.linkedin.com/in/stevestedman Background For 30+ years I have been working in the software development and database areas. I first started …
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and SQL Saturday Vancouver BC sessions. I am hoping to get three sessions accepted for Vancouver.
Other SQL Server CTE Material, Posts, and Samples On This Site CTE Hierarchy compared to the alternative Recursive CTE’s Calculating Factorials with a Recursive CTE Fibonacci Sequence CTE – With An Insert Statement Generating a Tree Path with a CTE …
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of the two. Who knows if my session will get accepted, but I am giving it …