Here is part of a faily long nested CTE. The whole query formats fine except for this section which starts at character 63.
FeeType ,
FeeSubType ,
ISNULL(( SELECT CommaDelimitedList = STUFF(( SELECT
', ' + Display
FROM
( SELECT DISTINCT
StudentID ,
fa.FinancialAidTypeID ,
Display
FROM
dbo.FINANCIAL_AID fa
WITH ( NOLOCK )
JOIN
dbo.FINANCIAL_AID_TYPE fat
WITH ( NOLOCK )
ON fa.FinancialAidTypeID = fat.FinancialAidTypeId
WHERE
fa.StudentID = ehv.StudentID AND
EnrollmentQuarterDate >= ( SELECT
BeginDate
FROM
Thanks,
Tom
Thanks,
Tom