SQL Tip: Creating Row Numbers

ConfigMgr Admins have asked about this before and I once wrote an internal post on this…here it is for anyone to see. Sometimes when writing a query it is helpful (or necessary) to have row numbers. In this SQL tip we’ll learn about “ROW_NUMBER”. Not surprisingly, ROW_NUMBER allows you to create a row number for…

0

SQL Tip: JOINs

Joins are an essential part to writing queries. When creating a result set from 2 or more tables the tables are joined. This tip will help describe the types of joins and why you’d use one over another. The JOIN types we will talk about are: INNER JOIN (aka JOIN) LEFT OUTER JOIN (aka LEFT…

2