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
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 FROMThanks,
Tom