{
for $MEASURE_2 in collection("PROD_DATA_DIC.dbo.MEASURE_2")/MEASURE_2,
$MEASURE_DEFINITION_2 in collection("PROD_DATA_DIC.dbo.MEASURE_DEFINITION_2")/MEASURE_DEFINITION_2
where $MEASURE_2/MEASURE_ID = $MEASURE_DEFINITION_2/MEASURE_ID
return
{$MEASURE_2/INDICATOR_KEY/text()}
{$MEASURE_2/AGENCY_GROUP_KEY/text()}
{$MEASURE_2/AGENCY/text()}
{$MEASURE_2/MEASURE_NAME/text()}
{$MEASURE_2/IsDocument/text()}
{$MEASURE_2/AgencyDocument/text()}
{$MEASURE_DEFINITION_2/DocumentKey/text()}
{$MEASURE_DEFINITION_2/DocumentValue/text()}
{$MEASURE_2/AgencyHREF/text()}
{$MEASURE_2/LinkHREF/text()}
{$MEASURE_2/LinkPage/text()}
}
(: Stylus Studio meta-information - (c) 2004-2007. Progress Software Corporation. All rights reserved.
:)