0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[Street],'')
ELSE Org.[Street]
END AS [Street]
,CASE
WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[City],'')
ELSE Org.[City]
END AS [City]
,CASE
WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[Region],'')
ELSE Org.[Region]
END AS [Region]
,CASE
WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(PCntry.[Name],'')
ELSE OCntry.[Name]
END AS [Country]
,CASE
WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[PostalCode],'')
ELSE Org.[PostalCode]
END AS [PostalCode]
FROM
[Person_View] Prsn
LEFT JOIN [Organization_View] Org ON Org.Id = Prsn.Organization
LEFT JOIN Country_View PCntry ON PCntry.Id = Prsn.Country
LEFT JOIN Country_View OCntry ON OCntry.Id = Org.Country
WHERE
(Prsn.[IsActive] = 'true' AND ISNULL(Org.[IsActive],'true') = 'true') OR @ShowAll = 'true'
ORDER BY
[Name], [Organization], [Country]
]]>
DataGrid