SSDT FOR VISUAL STUDIO 2015 TUTORIAL PDF HOW TO
SSDT FOR VISUAL STUDIO 2015 TUTORIAL PDF OFFLINE
Joanna Piros,a senior consultant with Counterpoint Communications and also faculty at UBC Sauder School of Business’s Executive Education program, was the one who delivered the one hour session.Īt the beginning of the session, Ms. One session I recently attended was “Conversations With Impact”. I love learning so it’s a field day for me when I get to attend these courses or events.īy Gareth Williams. One of the things I like about working at a university is having access to a number of learning opportunities, be it credit or not-for-credit courses, or even 1 or 2 hour sessions on anything. I feel quite lucky to be working where I work. Starting 2007, Client 0004 started purchasing again every year until 2012 (6 consecutive years). Here we can see Client 00004 purchased in 20 (2 consecutive years), but did not purchase in 2006. It will be easy to visually identify which clients have purchased consecutive years if we first display all the unique years that client has purchased: Let’s take it step by step to understand both the problem and solution better. Client 00004 purchased several times, and it looks like there were purchases in consecutive years.ĭownload sample T-SQL script to create and populate the SAMPLESALES table Notice that in this example, Client 00001, 0003 purchased only once. Your data may look like the following screenshot. Why? Perhaps in a marketing campaign, you may want to give your loyal customers (purchased in 5 or more consecutive years) a special discount. You may want to know what’s the maximum consecutive years they’ve purchased from you. You have multiple clients who could be purchasing from your store several times a year, or a couple of times every five years. Let’s assume you are working on a sales database. how to get the consecutive years of something (consecutive year sales, consecutive years in school, consecutive years volunteering etc), and his solution is pretty clever. The problem Joe solved is not uncommon – i.e.
I’ve tested this in SQL Server 2014, but should work from SQL Server 2005 onwards where the ranking functions are supported. This is an expansion (and slight variation) of Joe’s answer in StackOverflow regarding the thread Find the maximum consecutive years for each ID’s in a table (Oracle SQL) using SQL Server. If you’re not familiar with Tableau yet, you can start with this video to have a general idea how to create charts! This is just the tip of the iceberg. Initial focus has been with Tableau, but definitely want to add a lot of SQL Server (and MySQL) in this library. Here are some of my videos to date (YouTube: sqlbelle’s data adventures): It’s been fun, but definitely requires commitment. I’ve decided to try a new avenue to teach – YouTube! I’ve started my channel – sqlbelle’s data adventures – and hoping this can provide value and/or inspiration to those trying to learn data and technologies like Tableau and SQL Server. With the pandemic I had to switch to teaching exclusively online, and really re-think how I deliver my classes. I guess some issues still persist – perhaps in slightly different forms, but the way we solve or tackle them remain the same.Įxcited to share many things since I last blogged, but one of the biggest ones happened in the last couple of months. It’s been a while since I blogged (life got busy!), and am quite surprised to see that some of the posts I had are still getting traction.