I am using the same settings I was in SSMS18 but in 21 when I have variable declaration at the top and format the entire code it does 2 indentations for everything below it (1 indentation is expected after the BEGIN the other is undesired). I tried different settings but nothing changes this and it is very problematic because any formatted code with variables becomes unappealing. Another issue in this example that I am unsure how to fix is how the from and where in the subquery for @get_date_key do not align with SELECT.
Before:
After:
Hi @tholmberg,
thanks for your feedback.
This looks like the address / pointer to the formatting profiles is not ok. Did you set the path to the profiles in the Options>Setting menu?
Regards
Guido
@admin I just double checked this and restarted SSMS 21 and same issue persists. Here's showing that the path matches:
I should mention that other changes made in my profile do take effect as I make them.
Here is my current profile:
{
"RELEASE_GUI" : "SQLinForm 6.22.12.13",
"OUTPUT_LANGUAGE" : "SQL",
"GEN_NBR_SPACES_INDENT" : "3",
"CASE_KEYWORDS" : "UPPER",
"GEN_NBR_SP_TAB" : "4",
"GEN_SQL_AUTO_IND" : "NONE",
"EDIT_DEL_SPACES" : "True",
"SRCE_QUOTECHAR" : "'",
"IND_DOUBLEMASTERKEYWORD" : "False",
"GEN_ALWAYS_EXTRACT" : "False",
"GEN_ALWAYS_GENERATE" : "False",
"LB_DOUBLEUNION" : "False",
"LBB_COMMA" : "True",
"LBA_COMMA" : "False",
"LBB_AND" : "True",
"LBA_AND" : "False",
"LBA_SELECTBRACKET" : "True",
"LBA_CONDITIONBRACKET" : "False",
"GEN_DECIMALPOINT_IS_COMMA" : "False",
"EDIT_GENERATE_CODE" : "False",
"SRCE_IS_ENCLOSED" : "False",
"SRCE_IS_ENCLOSED_CHAR" : "''",
"LB_PAGEWIDTH" : "400",
"COLOR_SQL" : "True",
"IND_IF_THEN" : "False",
"IND_IF_ELSE" : "False",
"LBB_CASE" : "True",
"LB_WIDTH_SMALL_SQL" : "80",
"IND_AFT_SELECTBR" : "True",
"EDIT_USE_TABS_INDENT" : "False",
"IND_BEGIN_END" : "False",
"ALI_EQUAL" : "False",
"ALI_OPERATOR" : "True",
"SRCE_DB" : "SQL Server",
"ALI_RIGHTKEYWORD" : "True",
"EDIT_DEL_COMMENT" : "False",
"WHSP_BRACKET" : "ONEAROUND",
"LBA_IF" : "False",
"LBB_IF_THEN" : "False",
"LBA_IF_THEN" : "False",
"WHSP_COMMA" : "ONEAFTER",
"LBA_IF_ELSE" : "False",
"LBA_CASE" : "False",
"LBA_CASE_WHEN" : "False",
"LBB_CASE_END" : "True",
"WHSP_EQUAL" : "ONEAROUND",
"LBA_CASE_THEN" : "False",
"LBA_CASE_ELSE" : "False",
"IND_CASE_WHEN" : "True",
"ALI_AS" : "True",
"ALI_COMMENT" : "False",
"ALI_DECLARATION" : "False",
"LBB_CASE_THEN" : "False",
"LBB_CASE_ELSE" : "True",
"MY_VARIABLENAME" : "SQL",
"LBB_CASE_WHEN" : "True",
"LBB_CASE_ANDOR" : "False",
"EDIT_REPL_COMMENT" : "False",
"LBB_CONCAT" : "False",
"LBA_CONCAT" : "False",
"ALI_CONCAT" : "True",
"LBA_CASE_ANDOR" : "False",
"LBB_JOIN_ON" : "False",
"LBB_JOIN" : "True",
"SP_LB_NBR_COMMASPERLINE" : "1",
"LB_NBR_COMMASPERLINE" : "1",
"ALI_COMMA" : "False",
"LB_WIDTH_SMALL_CASE" : "150",
"IND_JOIN" : "True",
"IND_AFT_CONDITIONBR" : "False",
"IND_INITIALVALUE" : "0",
"SRCE_USE_ESCAPECHARACTER" : "True",
"EDIT_DELETE_EMPTYLINES" : "ALL",
"ALI_ASPOSITION" : "False",
"ALI_ASPOSITIONVALUE" : "60",
"WHSP_NONE_SQUARE_BRACKET" : "False",
"LBB_LINECOMMENT" : "False",
"LBB_BLOCKCOMMENT" : "False",
"SP_LBB_COMMA" : "False",
"SP_LBA_COMMA" : "False",
"LB_NBR_COMMASINLIST" : "1",
"EDIT_REPL_HOSTVARIABLE" : "False",
"EDIT_REMOVEBRACKETS" : "False",
"LB_ONELINESQL" : "False",
"IND_AUTO_1STLINE" : "False",
"IND_CASE_THEN" : "True",
"IND_CASE_ELSE" : "False",
"LBB_SELECTBRACKET" : "True",
"LBB_CONDITIONBRACKET" : "False",
"LBB_CLOSESELECTBRACKET" : "True",
"LBA_CLOSESELECTBRACKET" : "False",
"LBB_CLOSECONDITIONBRACKET" : "True",
"LBA_CLOSECONDITIONBRACKET" : "True",
"SP_LBB_OPENCONDITIONBR" : "False",
"SP_LBA_OPENCONDITIONBR" : "True",
"SP_IND_CONDITIONBR" : "False",
"SP_LBB_CLOSECONDITIONBR" : "True",
"SP_LBA_CLOSECONDITIONBR" : "True",
"SP_LBB_OPENPARMBRACKET" : "False",
"SP_LBA_OPENPARMBRACKET" : "False",
"SP_IND_PARMBRACKET" : "False",
"SP_LBB_CLOSEPARMBRACKET" : "False",
"SP_LBA_CLOSEPARMBRACKET" : "False",
"NOFORMATBETWEEN" : "True",
"NOFORMATSTART" : "FORMAT_OFF",
"NOFORMATEND" : "FORMAT_ON",
"LBB_OPENINSERTBRACKET" : "False",
"LBA_OPENINSERTBRACKET" : "False",
"LBB_CLOSEINSERTBRACKET" : "True",
"LBA_CLOSEINSERTBRACKET" : "False",
"IND_INSERTBRACKET" : "True",
"CASE_KEYWORDLIST" : "",
"VARIABLETYPES" : "",
"ALI_LEFTPARACOMMENT" : "False",
"IND_PARACOMMENT" : "False",
"LBB_OPENCASEBRACKET" : "False",
"LBA_OPENCASEBRACKET" : "True",
"LBB_CLOSECASEBRACKET" : "False",
"LBA_CLOSECASEBRACKET" : "False",
"IND_CASEBRACKET" : "True",
"ALI_MOVE_COMMALEFT" : "False",
"WHSP_1AFTERCOMMA" : "False",
"COLOR_MASTERKEYWORD_RGB" : "#CD5C5C",
"COLOR_LINECOMMENT_RGB" : "#000000",
"COLOR_BLOCKCOMMENT_RGB" : "#000000",
"COLOR_CASE_RGB" : "#00008B",
"COLOR_LITERAL_RGB" : "#CE7B00",
"COLOR_RESERVEDWORD_RGB" : "#CD5C5C",
"COLOR_STRUCTUREKEYWORD_RGB" : "#008000",
"IND_JOINON" : "False",
"COMMENTHOSTVARIABLE" : "False",
"COLOR_WHITESPACES" : "True",
"COLOR_IF_RGB" : "#FF0000",
"LB_STACKLISTGROUPBY" : "True",
"LB_STACKLISTORDERBY" : "True",
"ALI_ASSOCIATIONOPERATOR" : "False",
"SP_LBB_HEADER" : "True",
"SP_ALI_EQUAL" : "True",
"SP_ALI_ASSIGNMENT" : "False",
"EDIT_REPL_SINGLEQUOTE" : "False",
"LBA_WHERE" : "False",
"LBA_FROM" : "False",
"LBA_ORDERBY" : "False",
"LBA_GROUPBY" : "True",
"LBA_JOIN" : "False",
"LBA_JOIN_ON" : "False",
"LBA_SELECT" : "False",
"LB_NBR_COMMASINSERTPERLINE" : "1",
"LBA_UPDATE" : "False",
"LBA_DELETE" : "True",
"LBB_SEMIKOLON" : "False",
"LBA_HAVING" : "False",
"EDIT_REPL_PARACOMMENT" : "False",
"LBA_SEMIKOLON_DOUBLE" : "False",
"ALI_JOINON_AND_TO_ON" : "False",
"CASE_STATEMENT" : "NONE",
"CASE_NONKEYWORDS" : "LOWER",
"LBA_INTO" : "False",
"DELIMITER1" : ";",
"FIRSTLINEPREFIX" : "StringBuffer sql = new StringBuffer();",
"FIRSTLINESUFFIX" : "",
"BODYLINEPREFIX" : "sql.append(''",
"BODYLINESUFFIX" : "'');",
"LASTLINEPREFIX" : "",
"LASTLINESUFFIX" : "'');",
"LBB_LASTLINESUFFIX" : "False",
"DELIMITER2" : "",
"DELIMITER3" : "",
"NOFORMATWHOLESQL" : "False",
"COLOR_STANDARD_RGB" : "#000000",
"LBB_WHERE_AND" : "True",
"LBA_WHERE_AND" : "False",
"IND_WHERE_AND" : "True",
"LBB_HAVING_AND" : "True",
"LBA_HAVING_AND" : "False",
"IND_HAVING_AND" : "True",
"LBB_JOINON_AND" : "True",
"LBA_JOINON_AND" : "False",
"IND_JOINON_AND" : "True",
"ALI_MOVE_COMMALEFTBORDER" : "False",
"LBB_FROM" : "True",
"LBB_WHERE" : "True",
"LBB_HAVING" : "True",
"LBB_INTO" : "True",
"LBB_GROUPBY" : "True",
"LBB_ORDERBY" : "True",
"LBB_OPENCREATEBRACKET" : "False",
"LBA_OPENCREATEBRACKET" : "True",
"LBB_CLOSECREATEBRACKET" : "True",
"LBA_CLOSECREATEBRACKET" : "False",
"IND_CREATEBRACKETINSIDE" : "True",
"IND_CREATEBRACKETOUTSIDE" : "False",
"MY_FUNCTIONKEYWORDLIST" : "in",
"MY_CREATEKEYWORDLIST" : "",
"LB_NBR_COMMASINFUNCTIONLIST_L1" : "3",
"LB_NBR_COMMASINFUNCTIONLIST" : "3",
"ALI_COMMA_FUNCTIONLIST" : "True",
"MY_FUNCTIONKEYWORDLIST2" : "partition by",
"LB_NBR_COMMASINFUNCTIONLIST2_L1" : "1",
"LB_NBR_COMMASINFUNCTIONLIST2" : "1",
"ALI_COMMA_FUNCTIONLIST2" : "True",
"MY_FUNCTIONKEYWORDLIST3" : "over",
"LB_NBR_COMMASINFUNCTIONLIST3_L1" : "1",
"LB_NBR_COMMASINFUNCTIONLIST3" : "1",
"ALI_COMMA_FUNCTIONLIST3" : "True",
"LBB_COMMAINSERT" : "True",
"LBA_COMMAINSERT" : "False",
"LBB_COMMAUPDATE" : "True",
"LBA_COMMAUPDATE" : "False",
"LBB_SET_UPDATE" : "True",
"LBA_SET_UPDATE" : "False",
"LBA_MERGE" : "False",
"LBB_MERGE_USING" : "True",
"LBA_MERGE_USING" : "False",
"LBB_MERGE_ON" : "False",
"LBA_MERGE_ON" : "False",
"LBB_MERGEON_AND" : "True",
"LBA_MERGEON_AND" : "False",
"IND_MERGEON_AND" : "False",
"LBB_MERGEWHEN_AND" : "False",
"LBA_MERGEWHEN_AND" : "True",
"IND_MERGEWHEN_AND" : "True",
"LBB_MERGEWHEN_THEN" : "False",
"LBB_FUNCTIONLIST1_OPENBRACKET" : "False",
"LBB_FUNCTIONLIST2_OPENBRACKET" : "True",
"LBB_FUNCTIONLIST3_OPENBRACKET" : "False",
"LBA_FUNCTIONLIST1_OPENBRACKET" : "False",
"LBA_FUNCTIONLIST2_OPENBRACKET" : "True",
"LBA_FUNCTIONLIST3_OPENBRACKET" : "True",
"IND_FUNCTIONLIST1" : "False",
"IND_FUNCTIONLIST2" : "True",
"IND_FUNCTIONLIST3" : "True",
"LBB_OPENANALYTICBRACKET" : "False",
"LBA_OPENANALYTICBRACKET" : "True",
"LBB_CLOSEANALYTICBRACKET" : "False",
"LBA_CLOSEANALYTICBRACKET" : "False",
"IND_ANALYTICBRACKETINSIDE" : "True",
"IND_ANALYTICBRACKETOUTSIDE" : "True",
"LBB_ANALYTICPARTITIONBY" : "True",
"LB_STACKANALYTIC" : "True",
"ALI_MOVE_COMMALEFTONE" : "True",
"SP_LBB_COMMA_STATEMENT" : "True",
"SP_LBA_COMMA_STATEMENT" : "False",
"SP_ALI_MOVE_COMMALEFT_PARM" : "False",
"SP_ALI_MOVE_COMMALEFTONE_PARM" : "False",
"SP_ALI_MOVE_COMMALEFT_STMT" : "True",
"SP_ALI_MOVE_COMMALEFTONE_STMT" : "False",
"LBB_COMMA_DDL" : "True",
"LBA_COMMA_DDL" : "False",
"ALI_MOVE_COMMALEFT_DDL" : "False",
"ALI_MOVE_COMMALEFTONE_DDL" : "False",
"IND_NOFORMAT" : "False"
}
OK, thanks for the additional info. I will investigate.