SQL Tip: Creating Row Numbers

[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on Nov 28, 2011 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. Rather than rewrite this tip I’m leaving it as it was originally written, however, I have updated … Continue reading SQL Tip: Creating Row Numbers

SQL Tip: JOINs

[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on Nov 13, 2011 as part of a series I called ‘SQL Tips’ for coworkers and an email distribution list people could sign up to. Rather than rewrite this tip I’m leaving it as it was originally written, however, I have updated … Continue reading SQL Tip: JOINs