Hi Adam,

I wrote that article. There's not been any changes to the 9.2 database schema to effect the solution so it must be something else. Here's an example of a view I'm currently using:

SELECT	CONVERT(NVARCHAR(40),pv1.str_val) AS SoftwareProjectType, CONVERT(NVARCHAR(40),pv2.str_val) as DocumentType
FROM	laserficheDB.dbo.propval AS pv1
		inner join laserficheDB.dbo.propval AS pv2 ON pv1.tocid=pv2.tocid
		inner join laserficheDB.dbo.toc ON toc.tocid=pv1.tocid 
WHERE	pv1.prop_id=74
	and pv2.prop_id=73
	and toc.pset_id=6
	and (toc.toc_flags & 0x800 = 0)
	-- replace the line above with the line below in case of errors
	-- and (toc.toc_flags & convert(int,0x800) = 0)

Can you post your errors? I'll gladly help.

-Ben