Charlie

Concatenation is done using User Defined Functions. The following pulls out the Taxon Groups as a semi colon
separated string given the Survey_key as a parameter. Once you have installed the UDF you should  be able to work it into your query.

Mike 
 
USE [NBNData]
GO

/****** Object:  UserDefinedFunction [dbo].[LCFormatTaxonGroup]    Script Date: 12/02/2010 20:55:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[LCFormatTaxonGroup]
(@Survey_key char(16))
RETURNS varchar(8000)
--
--    DESCRIPTION
--    Function to return a semi-colon separated string of taxon groups within a survey
--   
--
--    PARAMETERS
--    NAME                DESCRIPTION
--    @Survey_Key            Survey Key.
--
--
--    AUTHOR:    Mike Weideli
--    CREATED: 02/12/2010
--

AS
BEGIN

--****************************************************************************************************
DECLARE @ReturnString varchar(8000)
DECLARE @Taxon_Groups  varchar(8000)

SET @Taxon_Groups    =''
SELECT @Taxon_Groups  = @Taxon_Groups   + D.Taxon_Group_Name  +  '; '
FROM
(SELECT  TAXON_GROUP_NAME FROM
Taxon_group TG
INNER JOIN
TAXON_VERSION TV ON TV.OUTPUT_GROUP_KEY = TG.TAXON_GROUP_KEY
INNER JOIN
TAXON_LIST_ITEM TLI ON TLI.TAXON_VERSION_KEY = TV.TAXON_VERSION_KEY
INNER JOIN TAXON_DETERMINATION TDET
ON TDET.TAXON_LIST_ITEM_KEY = TLI.TAXON_LIST_ITEM_KEY
INNER JOIN TAXON_OCCURRENCE TOCC
ON TOCC.TAXON_OCCURRENCE_KEY = TDET.TAXON_OCCURRENCE_KEY
INNER JOIN SAMPLE S
ON S.SAMPLE_KEY = TOCC.SAMPLE_KEY
INNER JOIN SURVEY_EVENT SE
ON SE.SURVEY_EVENT_KEY = S.SURVEY_EVENT_KEY
WHERE SE.SURVEY_KEY = @Survey_key GROUP BY TAXON_GROUP_NAME ) D

if len(@Taxon_Groups) > 0
BEGIN
  set  @RETURNSTRING  = left(@Taxon_groups,len(@Taxon_groups)-1)
END

--****************************************************************************************************
RETURN @ReturnString
END

GO

GRANT EXECUTE ON  [dbo].[LCFormatTaxonGroup] TO PUBLIC

Thank-you Mike!

The UDF is returning 8000 characters. Is the data in the R6 output truncated or just it does happen when it is exported to Excel ?