colors

I am travelling right now but will be back in the office on Monday. Could you please send me your sql statement to info@sqlinform.com . If possible, please attach also your exported profile. 

Regards

Guido

@admin Unexpected indention is because of DATEADD function.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
declare @atDate date = '2025-03-31' 
declare @fromDate date = dateadd(YY,-1,@atDate) --for calculating transactions only
declare @cp_code varchar(20) = '%'
declare @iso char(3) = 'NZL'
declare @endDate date = dateadd(d,1,@atDate) 
--select @atDate, @fromDate

SELECT distinct s.cpid as cp_code
	,'01' as cp_account_id
into #selectedAccounts
FROM x_sa_listOfSamples as s

for some reason I cannot attached the file, so just insert data from the file:

{
"RELEASE_GUI" : "SQLinForm 6.22.12.13",
"OUTPUT_LANGUAGE" : "SQL",
"GEN_NBR_SPACES_INDENT" : "2",
"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" : "True",
"LBB_COMMA" : "True",
"LBA_COMMA" : "False",
"LBB_AND" : "True",
"LBA_AND" : "False",
"LBA_SELECTBRACKET" : "False",
"LBA_CONDITIONBRACKET" : "False",
"GEN_DECIMALPOINT_IS_COMMA" : "True",
"EDIT_GENERATE_CODE" : "False",
"SRCE_IS_ENCLOSED" : "False",
"SRCE_IS_ENCLOSED_CHAR" : "''",
"LB_PAGEWIDTH" : "9999",
"COLOR_SQL" : "True",
"IND_IF_THEN" : "False",
"IND_IF_ELSE" : "False",
"LBB_CASE" : "False",
"LB_WIDTH_SMALL_SQL" : "10",
"IND_AFT_SELECTBR" : "True",
"EDIT_USE_TABS_INDENT" : "False",
"IND_BEGIN_END" : "False",
"ALI_EQUAL" : "True",
"ALI_OPERATOR" : "True",
"SRCE_DB" : "SQL Server",
"ALI_RIGHTKEYWORD" : "False",
"EDIT_DEL_COMMENT" : "False",
"WHSP_BRACKET" : "NOAROUND",
"LBA_IF" : "False",
"LBB_IF_THEN" : "True",
"LBA_IF_THEN" : "False",
"WHSP_COMMA" : "NOAROUND",
"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" : "False",
"ALI_AS" : "True",
"ALI_COMMENT" : "True",
"ALI_DECLARATION" : "True",
"LBB_CASE_THEN" : "True",
"LBB_CASE_ELSE" : "True",
"MY_VARIABLENAME" : "SQL",
"LBB_CASE_WHEN" : "True",
"LBB_CASE_ANDOR" : "False",
"EDIT_REPL_COMMENT" : "False",
"LBB_CONCAT" : "False",
"LBA_CONCAT" : "True",
"ALI_CONCAT" : "True",
"LBA_CASE_ANDOR" : "False",
"LBB_JOIN_ON" : "True",
"LBB_JOIN" : "True",
"SP_LB_NBR_COMMASPERLINE" : "1",
"LB_NBR_COMMASPERLINE" : "1",
"ALI_COMMA" : "True",
"LB_WIDTH_SMALL_CASE" : "10",
"IND_JOIN" : "False",
"IND_AFT_CONDITIONBR" : "True",
"IND_INITIALVALUE" : "0",
"SRCE_USE_ESCAPECHARACTER" : "False",
"EDIT_DELETE_EMPTYLINES" : "NONE",
"ALI_ASPOSITION" : "False",
"ALI_ASPOSITIONVALUE" : "60",
"WHSP_NONE_SQUARE_BRACKET" : "False",
"LBB_LINECOMMENT" : "False",
"LBB_BLOCKCOMMENT" : "True",
"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" : "True",
"LBB_SELECTBRACKET" : "True",
"LBB_CONDITIONBRACKET" : "False",
"LBB_CLOSESELECTBRACKET" : "True",
"LBA_CLOSESELECTBRACKET" : "False",
"LBB_CLOSECONDITIONBRACKET" : "True",
"LBA_CLOSECONDITIONBRACKET" : "False",
"SP_LBB_OPENCONDITIONBR" : "True",
"SP_LBA_OPENCONDITIONBR" : "False",
"SP_IND_CONDITIONBR" : "False",
"SP_LBB_CLOSECONDITIONBR" : "True",
"SP_LBA_CLOSECONDITIONBR" : "False",
"SP_LBB_OPENPARMBRACKET" : "False",
"SP_LBA_OPENPARMBRACKET" : "False",
"SP_IND_PARMBRACKET" : "True",
"SP_LBB_CLOSEPARMBRACKET" : "False",
"SP_LBA_CLOSEPARMBRACKET" : "False",
"NOFORMATBETWEEN" : "False",
"NOFORMATSTART" : "FORMAT_OFF",
"NOFORMATEND" : "FORMAT_ON",
"LBB_OPENINSERTBRACKET" : "True",
"LBA_OPENINSERTBRACKET" : "False",
"LBB_CLOSEINSERTBRACKET" : "True",
"LBA_CLOSEINSERTBRACKET" : "False",
"IND_INSERTBRACKET" : "True",
"CASE_KEYWORDLIST" : "LIMIT##PIVOT",
"VARIABLETYPES" : "",
"ALI_LEFTPARACOMMENT" : "True",
"IND_PARACOMMENT" : "True",
"LBB_OPENCASEBRACKET" : "False",
"LBA_OPENCASEBRACKET" : "False",
"LBB_CLOSECASEBRACKET" : "False",
"LBA_CLOSECASEBRACKET" : "False",
"IND_CASEBRACKET" : "False",
"ALI_MOVE_COMMALEFT" : "False",
"WHSP_1AFTERCOMMA" : "False",
"COLOR_MASTERKEYWORD_RGB" : "#0000FF",
"COLOR_LINECOMMENT_RGB" : "#008000",
"COLOR_BLOCKCOMMENT_RGB" : "#008000",
"COLOR_CASE_RGB" : "#0000FF",
"COLOR_LITERAL_RGB" : "#FF0000",
"COLOR_RESERVEDWORD_RGB" : "#0000FF",
"COLOR_STRUCTUREKEYWORD_RGB" : "#0000FF",
"IND_JOINON" : "False",
"COMMENTHOSTVARIABLE" : "False",
"COLOR_WHITESPACES" : "True",
"COLOR_IF_RGB" : "#FF0000",
"LB_STACKLISTGROUPBY" : "True",
"LB_STACKLISTORDERBY" : "True",
"ALI_ASSOCIATIONOPERATOR" : "True",
"SP_LBB_HEADER" : "True",
"SP_ALI_EQUAL" : "True",
"SP_ALI_ASSIGNMENT" : "True",
"EDIT_REPL_SINGLEQUOTE" : "False",
"LBA_WHERE" : "False",
"LBA_FROM" : "False",
"LBA_ORDERBY" : "False",
"LBA_GROUPBY" : "False",
"LBA_JOIN" : "False",
"LBA_JOIN_ON" : "False",
"LBA_SELECT" : "False",
"LB_NBR_COMMASINSERTPERLINE" : "1",
"LBA_UPDATE" : "False",
"LBA_DELETE" : "False",
"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" : "NONE",
"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" : "False",
"LBB_HAVING_AND" : "True",
"LBA_HAVING_AND" : "False",
"IND_HAVING_AND" : "False",
"LBB_JOINON_AND" : "True",
"LBA_JOINON_AND" : "False",
"IND_JOINON_AND" : "False",
"ALI_MOVE_COMMALEFTBORDER" : "False",
"LBB_FROM" : "True",
"LBB_WHERE" : "True",
"LBB_HAVING" : "True",
"LBB_INTO" : "True",
"LBB_GROUPBY" : "True",
"LBB_ORDERBY" : "True",
"LBB_OPENCREATEBRACKET" : "True",
"LBA_OPENCREATEBRACKET" : "True",
"LBB_CLOSECREATEBRACKET" : "True",
"LBA_CLOSECREATEBRACKET" : "True",
"IND_CREATEBRACKETINSIDE" : "True",
"IND_CREATEBRACKETOUTSIDE" : "False",
"MY_FUNCTIONKEYWORDLIST" : "in",
"MY_CREATEKEYWORDLIST" : "",
"LB_NBR_COMMASINFUNCTIONLIST_L1" : "1",
"LB_NBR_COMMASINFUNCTIONLIST" : "1",
"ALI_COMMA_FUNCTIONLIST" : "False",
"MY_FUNCTIONKEYWORDLIST2" : "",
"LB_NBR_COMMASINFUNCTIONLIST2_L1" : "1",
"LB_NBR_COMMASINFUNCTIONLIST2" : "1",
"ALI_COMMA_FUNCTIONLIST2" : "False",
"MY_FUNCTIONKEYWORDLIST3" : "",
"LB_NBR_COMMASINFUNCTIONLIST3_L1" : "1",
"LB_NBR_COMMASINFUNCTIONLIST3" : "1",
"ALI_COMMA_FUNCTIONLIST3" : "False",
"LBB_COMMAINSERT" : "False",
"LBA_COMMAINSERT" : "True",
"LBB_COMMAUPDATE" : "False",
"LBA_COMMAUPDATE" : "True",
"LBB_SET_UPDATE" : "True",
"LBA_SET_UPDATE" : "True",
"LBA_MERGE" : "True",
"LBB_MERGE_USING" : "True",
"LBA_MERGE_USING" : "True",
"LBB_MERGE_ON" : "True",
"LBA_MERGE_ON" : "False",
"LBB_MERGEON_AND" : "True",
"LBA_MERGEON_AND" : "False",
"IND_MERGEON_AND" : "False",
"LBB_MERGEWHEN_AND" : "False",
"LBA_MERGEWHEN_AND" : "False",
"IND_MERGEWHEN_AND" : "False",
"LBB_MERGEWHEN_THEN" : "False",
"LBB_FUNCTIONLIST1_OPENBRACKET" : "False",
"LBB_FUNCTIONLIST2_OPENBRACKET" : "False",
"LBB_FUNCTIONLIST3_OPENBRACKET" : "False",
"LBA_FUNCTIONLIST1_OPENBRACKET" : "False",
"LBA_FUNCTIONLIST2_OPENBRACKET" : "False",
"LBA_FUNCTIONLIST3_OPENBRACKET" : "False",
"IND_FUNCTIONLIST1" : "False",
"IND_FUNCTIONLIST2" : "False",
"IND_FUNCTIONLIST3" : "False",
"LBB_OPENANALYTICBRACKET" : "False",
"LBA_OPENANALYTICBRACKET" : "False",
"LBB_CLOSEANALYTICBRACKET" : "False",
"LBA_CLOSEANALYTICBRACKET" : "False",
"IND_ANALYTICBRACKETINSIDE" : "False",
"IND_ANALYTICBRACKETOUTSIDE" : "False",
"LBB_ANALYTICPARTITIONBY" : "False",
"LB_STACKANALYTIC" : "False",
"ALI_MOVE_COMMALEFTONE" : "False",
"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" : "False",
"SP_ALI_MOVE_COMMALEFTONE_STMT" : "False",
"LBB_COMMA_DDL" : "False",
"LBA_COMMA_DDL" : "True",
"ALI_MOVE_COMMALEFT_DDL" : "False",
"ALI_MOVE_COMMALEFTONE_DDL" : "False"
}

Thanks. This was very helpful. I found the issue. Will fix this today.

The issue with the wrong indention has been fixed.

it works for desktop version, but for SSMS there are only 2 files in zip again:

As the installation Routine for SSMS 18, 19, 20 is 99% identical I put them all in one installation package

Just choose your SSMS Release

@admin Hi , it looks like something is wrong with package. I could not even start "SQLinForm Plugin for SSMS.exe". Nothing is pop-up. I have run it under admin.

Please double check the files.

@idol,

ok, I published the zip file again. Now, it also includes a folder SSMSPlugin. If the installation routine does not work then please copy the SSMSPlugin Folder:

• SSMS 18 --> C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\
• SSMS 19 --> C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\
• SSMS 20 --> C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\

Thanks for your patience

@admin It does not work.

If just copy the folder SSMSPlugin, error:

My system does not block your exe file. (note, the file was renamed to avoid spaces):

Hi @idol,

it looks like the tool I use to create the setup.exe is not working the way I want.

I went back to the 3 file solution, i.e. one for each SSMS18, SSMS19, SSMS20

I installed a completely new computer with fresh SSMS installation and it worked

Could you please try again 

The downloaded zip file should contain these 4 files

Thanks for your patience

@admin it works , thanks.