Benjamin's blog

SQL & Inventory tips, tricks, and random thoughts (generally geared toward the Configuration Manager Admin)

February, 2014

  • 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”...
  • 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: ...