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

Adding Summaries to ConfigMgr 2012 SSRS Reports

Technorati Tags: ConfigMgr,SCCM,System Center Configuration Manager,SSRS,Reports The ConfigMgr 2007 reports have a record count at the top of the reports. The reports in ConfigMgr 2012 do not. I'll be walking through the steps of how to add this to your 2012 reports. Additionally, if you're unfamiliar with SSRS or "Report Builder" this will be a…

3