(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 have out there, and you order the results by the ProductVersion (if you use V_GS_SoftwareProduct) or fileVersion (if you use V_GS_SoftwareFile), you...
Posted to
Number2 Blog - MyITForum.com
(Weblog)
by
jnelson
on
11-13-2007
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