After a certain amount of characters it quits formatting

tshad

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

Anu D

Thanks for your post!

We have logged a support call for you and will send an email shortly.

Have a great day ahead!