After a certain amount of characters it quits formatting

tshadtshad Posts: 17 Bronze 2
edited October 23, 2013 6:45AM in SQL Prompt
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

Comments

Sign In or Register to comment.