By Posted on Posted in CTE, SQL Saturday 2 Comments Tagged with , , , , ,

Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me on Twitter to stay informed of future presentations. Download the Presentation Here: Unleashing …

Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »

By Posted on Posted in SQL 2012, SQL Saturday 2 Comments Tagged with , , , ,

I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats New in TSQL 2012 If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me …

Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »

By Posted on Posted in TSQL No Comments Tagged with , , , , , ,

As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012.  But what if you want to generate letters instead of numbers. Here is a code example of a sequence used to generate letters (indirectly). Which generates the following output. Just another cool trick with new features in …

TSQL 2012 – Generating letters with a SEQUENCE object Read more »

By Posted on Posted in SQL 2012 No Comments Tagged with , , , , ,

SQL Server 2012 introduces the SEQUENCE object.  Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years.  I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers to SQL Server. First off what is a SEQUENCE… A user-defined object that generates a sequence of numeric values. To create …

SQL Server 2012 – SEQUENCE Read more »

By Posted on Posted in CTE, SQL Saturday 2 Comments Tagged with , , , , , ,

Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get in touch with me on Twitter  @SqlEmt  Remember to follow me on Twitter to stay informed of future presentations. …

Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »

By Posted on Posted in CTE, SQL Saturday No Comments Tagged with , , , , , ,

Its going to be a great day!   Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE if you are interested in any of the following: 1.What is a Common Table Expression 2.Simple CTE 3.CTE – Subquery …

SQL Saturday #172 in Portland Oregon Read more »

By Posted on Posted in CTE, SQL Saturday No Comments Tagged with , , , ,

On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few more examples of how CTE’s can be used in common practice. Using a CTE to parse a Query String. Using …

Unleashing Common Table Expressions Read more »