How is SQL Prompt helping your team? Share your experience.
After a certain amount of characters it quits formatting

Here is part of a faily long nested CTE. The whole query formats fine except for this section which starts at character 63.
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 FROM
Thanks,
Tom
Comments
We have logged a support call for you and will send an email shortly.
Have a great day ahead!
Product Support
Redgate Software Ltd.
E-mail: [email protected]