Saskatoon SQL Server User Group

Next Meeting

Friday,

February

24

Meeting 2 of 2017

This is meeting number 2 of 2017.

the topic has been chosen and this is the first meeting that I have set up that has an RSVP.
If you have troubles with the RSVP, please let me know at the next meeting and I can work on a different RSVP system.

Just noticed the RSVP URL doesn't show up on the main page.  Not sure how that is supposed to work from the admin side, but here is the RSVP link:
https://www.eventbrite.com/e/sql-saskatoon-user-group-tickets-31484498984

The topic is going to be 

Advanced Common Table Expressions and Recursive Query Technique

the abstract is:

You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE, and DELETE data from CTEs? This session covers some common use cases for CTEs, including finding holes in patterns, finding and removing duplicate data, string parsing, and more. Get an in-depth understanding of the performance behind a CTE and learn when a CTE is the right (or wrong) solution. Finally, take a look at some classic recursive algorithms and how they can be implemented with CTEs.


PASSChapterLogo.jpg

Upcoming PASS Sponsored Events:

  • ONLINE EVENTS:

  • IN PERSON EVENTS:

  • 24 hours of PASS - here

    PASS BA Days - here
    BA Marathon - herePASS affiliated conferences - here

    And can't forget SQLSaturday (aka mini-Summit) - here

    Back to Top
    cage-aids
    cage-aids
    cage-aids
    cage-aids