SELECT '(All)' as 'Name', '0' AS OrganizationID

UNION

SELECT Name, OrganizationID

FROM Polaris.Organizations

WHERE ParentOrganizationID = @Parent





IF @Branch = 0

BEGIN

SELECT PO.Name as 'Org', 

CASE 

WHEN PC.Name IS NULL THEN '(none)'

ELSE PC.Name

END as 'Collection', Count(IR.ItemRecordID) as 'Count'

FROM Polaris.ItemRecords IR

JOIN Polaris.Organizations PO

ON PO.OrganizationID = IR.OwningBranchID

LEFT JOIN Polaris.Collections PC ON

PC.CollectionID = IR.AssignedCollectionID

WHERE IR.RecordStatusID = 1 --not deleted

AND PO.ParentOrganizationID = @Parent

AND IR.MaterialTypeID NOT IN (26)

GROUP BY PO.Name, PC.Name

ORDER BY PO.Name, PC.Name 

END

ELSE 

BEGIN

SELECT PO.Name as 'Org', 

CASE 

WHEN PC.Name IS NULL THEN '(none)'

ELSE PC.Name

END as 'Collection', Count(IR.ItemRecordID) as 'Count'

FROM Polaris.ItemRecords IR

JOIN Polaris.Organizations PO

ON PO.OrganizationID = IR.OwningBranchID

LEFT JOIN Polaris.Collections PC ON

PC.CollectionID = IR.AssignedCollectionID

WHERE IR.RecordStatusID = 1 --not deleted

AND PO.OrganizationID = @Branch

AND IR.MaterialTypeID NOT IN (26)

GROUP BY PO.Name, PC.Name

ORDER BY PO.Name, PC.Name

END