Here is a snippet where the formatting is not working 100%. The first COALESCE is formatting as I expect and want. But the second COALESCE that is creating the ending parameter for the BETWEEN is not formatting, but being left all on one line. I would also expect that the AND along with the ending parameter of the BETWEEN would be on their own lines.
AND @CurrentDate BETWEEN DATEADD(mm, -3,
COALESCE(AssignmentBaseline10Start,
AssignmentBaseline9Start,
AssignmentBaseline8Start,
AssignmentBaseline7Start,
AssignmentBaseline6Start,
AssignmentBaseline5Start,
AssignmentBaseline4Start,
AssignmentBaseline3Start,
AssignmentBaseline2Start,
AssignmentBaseline1Start,
AssignmentStart)) AND COALESCE(AssignmentBaseline10Finish, AssignmentBaseline9Finish, AssignmentBaseline8Finish, AssignmentBaseline7Finish, AssignmentBaseline6Finish, AssignmentBaseline5Finish, AssignmentBaseline4Finish, AssignmentBaseline3Finish, AssignmentBaseline2Finish, AssignmentBaseline1Finish, AssignmentFinish)
Tim
Denver, CO
AND @CurrentDate BETWEEN DATEADD(mm, -3,
COALESCE(AssignmentBaseline10Start,
AssignmentBaseline9Start,
AssignmentBaseline8Start,
AssignmentBaseline7Start,
AssignmentBaseline6Start,
AssignmentBaseline5Start,
AssignmentBaseline4Start,
AssignmentBaseline3Start,
AssignmentBaseline2Start,
AssignmentBaseline1Start,
AssignmentStart)) AND COALESCE(AssignmentBaseline10Finish, AssignmentBaseline9Finish, AssignmentBaseline8Finish, AssignmentBaseline7Finish, AssignmentBaseline6Finish, AssignmentBaseline5Finish, AssignmentBaseline4Finish, AssignmentBaseline3Finish, AssignmentBaseline2Finish, AssignmentBaseline1Finish, AssignmentFinish)
Tim
Denver, CO