Day 7 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at the introduction to recursive CTEs. These queries will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t set up the sample database, download it and set it up now. The recursive feature …
Day 5 of Common Table Expression Month (June) at SteveStedman.com, today I will cover concepts around the scope of a CTE. The queries in the video will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t set up the sample database, download it and set it up now. Where is …
This is my 250th blog post at Steve Stedman.com. Many of the post over the last year have been focused on Common Table Expression topics as I finished my CTE Book, however with last month being DBCC Command Month here there were many posts completely unrelated to CTEs. Another category that accounts for many of the posts is the Database …
As a first time published author it is exciting to see that my Common Table Expressions book is now available on the Amazon.co.uk website. It showed up on Amazon.com about a week ago, and now its available in the UK. I just need to blog about my excitement as the book shows up in different places.
My common Table Expressions book became available on Amazon.com late last week. After presenting on Common Table Expressions at SQL Saturday yesterday, the sales jumped a bit to the point that the CTE Book is now #2 in the Hot New releases for Computer Databases section at Amazon.com as shown in the image below. This is so exciting after all …