Hi @Michael ,
Here is a query I had lying around ...
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDSELECT CASE WHEN itg.itemtypegroupname IS NULL THEN CASE WHEN dt.itemtypename IS NULL THEN '-- Grand Total' END ELSE itg.itemtypegroupname -- Document Type Group Total END as 'Document Type Group Name', CASE WHEN dt.itemtypename IS NULL THEN CASE WHEN itg.itemtypegroupname IS NULL THEN '-- Document Type Grand Total' ELSE '-- Document Type Group Total' END ELSE dt.itemtypename -- Document Type Total END as 'Document Type Name', COUNT(id.itemnum) as 'Document Type Count' FROM hsi.itemdata idJOIN hsi.doctype dt ON dt.itemtypenum = id.itemtypenumJOIN hsi.itemtypegroup itg ON itg.itemtypegroupnum = id.itemtypegroupnumGROUP BY itg.itemtypegroupname, dt.itemtypename with ROLLUPORDER BY itg.itemtypegroupname ASC
Best wishes.
