v_GS_SoftwareFile - Number2 Blog

SQL Oddity - OUTER JOINs with criteria act like INNER JOIN by jnelson

SYMPTOMS You have a query with an OUTER JOIN (aka LEFT JOIN, RIGHT JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN), and you need to put filter criteria on the...

Filed under: SQL, SMS, SMS 2003, sql 2005, v_GS_SoftwareFile, right outer join, inner join, right join, join, v_FullCollectionMembership, left outer join, outer join, V_R_System, left join

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson

RECOMMENDED READING First of all, you should read this article I wrote entitled " How to get the CORRECT order when sorting on version numbers like...

Filed under: SQL, SMS, SMS 2003, Microsoft Systems Management Server, web report, webreport, outlook, v_ProductFileInfo, BIGINT, CAST, itemExtract, sql 2005, v_GS_SoftwareFile, v_GS_SoftwareProduct, GROUP BY, DISTINCT

SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx by jnelson

(UPDATE: This post was updated 2008-08-16. Skip to the end to see the update) THE PROBLEM Let's say you query SMS to find all versions of Outlook you...

Filed under: SQL, SMS, SMS 2003, outlook, udf_ItemExtract, v_ProductFileInfo, INT, BIGINT, CAST, itemExtract, order by, sql 2005, v_GS_SoftwareFile, SUBSTRING, CHARINDEX, sorting, v_GS_SoftwareProduct

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

Browse by Tags

SQL Oddity - OUTER JOINs with criteria act like INNER JOIN by jnelson

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson

SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx by jnelson