Search
Post Calendar
February 2023 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 My Tweets
- We just backed Ten Plagues the Card Game on @Kickstarter kickstarter.com/projects/64044… https://t.co/1hIFAxaLHd 3 months ago
- I just entered to win a $50 Miniature Market Gift Card with help from @TheGameBoyGeek ! gameboygeek.com/contest 5 years ago
- Help Sydney travel Abroad gofundme.com/help-sydney-tr… 6 years ago
- Got to meet zee @dtconofficial https://t.co/m0YUdcLVOr 6 years ago
- RT @StrateSQL: Mikes entering sandman #sqlkaraoke vine.co/v/eYUJrV0JAiK 7 years ago
Pass Summit 2011
SQL Rally
Meta
Tag Archives: T-SQL
Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers. For example, instead of this: 3/1/2011 You want to see this: 03/01/2011 There is an easy way to do this using the Right() function … Continue reading
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE). The first CTE gets the standard deviation and the … Continue reading
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular basis. To do this I needed to get the last GPA record on the table and the previous GPA. The … Continue reading
Sorting a String as a Number with T-SQL and SSIS
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not … Continue reading
SQL PASS Summit 2011 The Aftermath
I just returned from Seattle, WA and my first time speaking at SQL PASS Summit. I did the SQL Smackdown T-SQL vs SSIS Loading a Data Warehouse with Adam Jorgensen. The session was a hit, it was standing room only … Continue reading