How can we help you today? How can we help you today?
RTSJohn
Activity overview Badges (0) Posts (2) Comments (4)

Activity overview

Latest activity by RTSJohn

Collapsed formatting question
  1. Community
  2. SQL Prompt
How can I get the below sample to collapse all the state entries to use the least number of lines yet still wordwrap?  All I'm able to get right now is one state per line no matter what I do with t...
1 follower 2 comments 0 votes
After updating to SQL Prompt 10, I'm no longer receiving the error. / comments
  1. Community
  2. SQL Prompt
  3. Formatting an UPDATE query with multiple items in SET phrase
After updating to SQL Prompt 10, I'm no longer receiving the error.
0 votes
Here's the file I'm using. <?xml version="1.0" encoding="utf-8"?> <LayoutOptions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Format.Engine.Formatting.Options">   <AlignCaseElseToWhen>true</AlignCaseElseToWhen>   <AlignToTab>false</AlignToTab>   <BetweenAndAlignment>ToBetween</BetweenAndAlignment>   <BooleanOperatorAlignment>AsPartOfList</BooleanOperatorAlignment>   <BooleanOperatorBreakType>ChopIfLong</BooleanOperatorBreakType>   <BreakAssignmentIfLong>true</BreakAssignmentIfLong>   <BreakOnConstraints>true</BreakOnConstraints>   <BuiltInDataTypeCasing>Uppercase</BuiltInDataTypeCasing>   <BuiltInFunctionCasing>Uppercase</BuiltInFunctionCasing>   <CaseEndAlignment>ToCase</CaseEndAlignment>   <CaseExpressionAlignment>Tabbed</CaseExpressionAlignment>   <CaseWhenElseAlignment>Tabbed</CaseWhenElseAlignment>   <ClauseAlignment>ToStatement</ClauseAlignment>   <ClauseIndentation>0</ClauseIndentation>   <ClosingParenthesisAlignment>ToOpeningBracket</ClosingParenthesisAlignment>   <CollapseCaseExpressionIfShort>false</CollapseCaseExpressionIfShort>   <CollapseCaseIfShortCharacterCount>75</CollapseCaseIfShortCharacterCount>   <CollapseIfShortControlFlowCharacterCount>78</CollapseIfShortControlFlowCharacterCount>   <CollapseIfShortDdlCharacterCount>75</CollapseIfShortDdlCharacterCount>   <CollapseIfShortDmlCharacterCount>78</CollapseIfShortDmlCharacterCount>   <CollapseIfShortParenthesesContentsCharacterCount>75</CollapseIfShortParenthesesContentsCharacterCount>   <CollapseIfShortSubqueryCharacterCount>78</CollapseIfShortSubqueryCharacterCount>   <CollapseShortControlFlowStatements>true</CollapseShortControlFlowStatements>   <CollapseShortDdlStatements>true</CollapseShortDdlStatements>   <CollapseShortDmlStatements>true</CollapseShortDmlStatements>   <CollapseShortParenthesesContents>true</CollapseShortParenthesesContents>   <CollapseShortSubqueries>true</CollapseShortSubqueries>   <CommaAlignment>ToList</CommaAlignment>   <ConstraintColumnsBreakType>ChopIfLongOrMultipleItems</ConstraintColumnsBreakType>   <CreateAlterClosingParenthesisAlignment>ToOpeningBracket</CreateAlterClosingParenthesisAlignment>   <CreateAlterIndentParenthesisedExpression>true</CreateAlterIndentParenthesisedExpression>   <CreateAlterOpeningParenthesisAlignment>ToStatement</CreateAlterOpeningParenthesisAlignment>   <CreateAlterOpeningParenthesisBreakType>ChopAlways</CreateAlterOpeningParenthesisBreakType>   <CreateAlterParenthesisLayout>ExpandedToStatement</CreateAlterParenthesisLayout>   <CreateAlterParenthesisedExpressionBreakType>ChopAlways</CreateAlterParenthesisedExpressionBreakType>   <CreateAlterPlaceClosingParenthesisOnNewLine>true</CreateAlterPlaceClosingParenthesisOnNewLine>   <CreateTableBreakBeforeFirstListItem>true</CreateTableBreakBeforeFirstListItem>   <CteAsAlignment>ToStatement</CteAsAlignment>   <CteColumnsOpeningParenthesisAlignment>ToStatement</CteColumnsOpeningParenthesisAlignment>   <CteColumnsOpeningParenthesisBreakType>Never</CteColumnsOpeningParenthesisBreakType>   <CteContentsOpeningParenthesisAlignment>ToStatement</CteContentsOpeningParenthesisAlignment>   <CteContentsOpeningParenthesisBreakType>Never</CteContentsOpeningParenthesisBreakType>   <CteContentsParenthesisLayout>CompactSimple</CteContentsParenthesisLayout>   <CteContentsParenthesisedExpressionAlignment>ToStartOfOpeningBracket</CteContentsParenthesisedExpressionAlignment>   <CteContentsParenthesisedExpressionBreakType>Never</CteContentsParenthesisedExpressionBreakType>   <FirstCreateAlterDefintionBreakType>ChopIfLongOrMultipleItems</FirstCreateAlterDefintionBreakType>   <FirstCreateProcedureParamBreakType>ChopIfLongOrMultipleItems</FirstCreateProcedureParamBreakType>   <FirstListItemBreakType>ChopIfLongOrMultipleItems</FirstListItemBreakType>   <FromClauseFirstItemBreakType>Never</FromClauseFirstItemBreakType>   <FunctionArgumentsBreakType>ChopIfLong</FunctionArgumentsBreakType>   <GlobalVariablesCasing>LeaveAsIs</GlobalVariablesCasing>   <GroupByOrderByFirstItemBreakType>Never</GroupByOrderByFirstItemBreakType>   <InValuesFirstItemBreakType>SimpleWrap</InValuesFirstItemBreakType>   <InValuesOpeningParenthesisAlignment>ToStatement</InValuesOpeningParenthesisAlignment>   <InValuesOpeningParenthesisBreakType>Never</InValuesOpeningParenthesisBreakType>   <InValuesSubsequentListItemsBreakType>SimpleWrap</InValuesSubsequentListItemsBreakType>   <IndentBeginEndKeywords>false</IndentBeginEndKeywords>   <IndentBlockContents>true</IndentBlockContents>   <IndentCteContents>false</IndentCteContents>   <IndentCteName>false</IndentCteName>   <IndentDdlClauses>false</IndentDdlClauses>   <IndentInsertColumnListsParenthesisedExpression>true</IndentInsertColumnListsParenthesisedExpression>   <IndentInsertValuesListsParenthesisedExpression>true</IndentInsertValuesListsParenthesisedExpression>   <IndentJoinTable>false</IndentJoinTable>   <IndentListItems>true</IndentListItems>   <IndentParenthesisedExpression>true</IndentParenthesisedExpression>   <InsertColumnListParenthesisLayout>ExpandedToStatement</InsertColumnListParenthesisLayout>   <InsertEmptyLineBetweenJoins>false</InsertEmptyLineBetweenJoins>   <InsertValuesListParenthesisLayout>CompactToStatement</InsertValuesListParenthesisLayout>   <IsMigratedStyle>false</IsMigratedStyle>   <JoinBreakType>ChopAlways</JoinBreakType>   <JoinClauseAlignment>Tabbed</JoinClauseAlignment>   <JoinConditionBreakType>Never</JoinConditionBreakType>   <JoinOnAlignment>TabbedFromJoin</JoinOnAlignment>   <JoinOnConditionAlignment>Tabbed</JoinOnConditionAlignment>   <Name>John</Name>   <NewLineAfterTopRowFilter>true</NewLineAfterTopRowFilter>   <NewLineBeforeTopRowFilter>false</NewLineBeforeTopRowFilter>   <NewLineForCorrelatedTableSource>true</NewLineForCorrelatedTableSource>   <NumberOfEmptyLinesAfterBatchSeparator>1</NumberOfEmptyLinesAfterBatchSeparator>   <NumberOfEmptyLinesBetweenStatements>1</NumberOfEmptyLinesBetweenStatements>   <NumberOfSpacesInTab>4</NumberOfSpacesInTab>   <OpeningParenthesisAlignment>ToStatement</OpeningParenthesisAlignment>   <OpeningParenthesisBreakType>ChopAlways</OpeningParenthesisBreakType>   <OptionsVersion>12</OptionsVersion>   <OverrideParenthesesOptionsForCreateAlterStatements>true</OverrideParenthesesOptionsForCreateAlterStatements>   <ParenthesisLayout>CompactIndented</ParenthesisLayout>   <ParenthesisedExpressionAlignment>TabbedFromOpeningBracket</ParenthesisedExpressionAlignment>   <ParenthesisedExpressionBreakType>ChopAlways</ParenthesisedExpressionBreakType>   <PlaceBeginOnNewLine>true</PlaceBeginOnNewLine>   <PlaceCaseElseOnNewLine>true</PlaceCaseElseOnNewLine>   <PlaceCaseEndOnNewLine>true</PlaceCaseEndOnNewLine>   <PlaceCaseExpressionOnNewLine>true</PlaceCaseExpressionOnNewLine>   <PlaceCaseFirstWhenOnNewLine>Always</PlaceCaseFirstWhenOnNewLine>   <PlaceClosingParenthesisOnNewLine>true</PlaceClosingParenthesisOnNewLine>   <PlaceCommasBeforeListItems>false</PlaceCommasBeforeListItems>   <PlaceJoinOnKeywordOnANewLine>true</PlaceJoinOnKeywordOnANewLine>   <PlaceJoinTableOnNewLine>false</PlaceJoinTableOnNewLine>   <PreferBreakBeforeAsKeyword>true</PreferBreakBeforeAsKeyword>   <PreferBreakBeforeBetweenAndKeyword>false</PreferBreakBeforeBetweenAndKeyword>   <PreferBreakBeforeBetweenKeyword>true</PreferBreakBeforeBetweenKeyword>   <PreferBreakBeforeConditionOperator>true</PreferBreakBeforeConditionOperator>   <PreferBreakBeforeCteName>false</PreferBreakBeforeCteName>   <PreferBreakBeforeEquals>true</PreferBreakBeforeEquals>   <PreferBreakBeforeInsertTable>false</PreferBreakBeforeInsertTable>   <PreferBreakBeforeThenKeyword>false</PreferBreakBeforeThenKeyword>   <PreserveLineSpacingBetweenStatements>true</PreserveLineSpacingBetweenStatements>   <PreserveLineSpacingWithinStatements>false</PreserveLineSpacingWithinStatements>   <ReservedKeywordsCasing>Uppercase</ReservedKeywordsCasing>   <SemicolonWhitespace>None</SemicolonWhitespace>   <SpaceBeforeUnits>false</SpaceBeforeUnits>   <SpaceBetweenDataTypeAndParameters>false</SpaceBetweenDataTypeAndParameters>   <SpaceInsideEmptyParentheses>false</SpaceInsideEmptyParentheses>   <SpacesAroundArithmeticOperators>     <m_After>true</m_After>     <m_Before>true</m_Before>   </SpacesAroundArithmeticOperators>   <SpacesAroundCommas>     <m_After>true</m_After>     <m_Before>false</m_Before>   </SpacesAroundCommas>   <SpacesAroundComparisonOperators>     <m_After>true</m_After>     <m_Before>true</m_Before>   </SpacesAroundComparisonOperators>   <SpacesAroundFunctionCallArguments>     <m_After>false</m_After>     <m_Before>false</m_Before>   </SpacesAroundFunctionCallArguments>   <SpacesAroundFunctionCalls>     <m_After>true</m_After>     <m_Before>false</m_Before>   </SpacesAroundFunctionCalls>   <SpacesAroundInPredicateContents>     <m_After>true</m_After>     <m_Before>true</m_Before>   </SpacesAroundInPredicateContents>   <SpacesAroundParentheses>     <m_After>false</m_After>     <m_Before>false</m_Before>   </SpacesAroundParentheses>   <SpacesAroundParenthesesContents>     <m_After>false</m_After>     <m_Before>false</m_Before>   </SpacesAroundParenthesesContents>   <SpacesOrTabs>OnlySpaces</SpacesOrTabs>   <SubsequentInsertColumnsListItemsBreakType>ChopAlways</SubsequentInsertColumnsListItemsBreakType>   <SubsequentInsertValuesListItemsBreakType>SimpleWrap</SubsequentInsertValuesListItemsBreakType>   <SubsequentListItemsBreakType>ChopAlways</SubsequentListItemsBreakType>   <UseGlobalListOptionsForDmlStatements>false</UseGlobalListOptionsForDmlStatements>   <UseObjectDefinitionCase>true</UseObjectDefinitionCase>   <VerticallyAlignAliases>false</VerticallyAlignAliases>   <VerticallyAlignClauseItems>false</VerticallyAlignClauseItems>   <VerticallyAlignColumnDefinitions>false</VerticallyAlignColumnDefinitions>   <VerticallyAlignComparisonOperators>false</VerticallyAlignComparisonOperators>   <VerticallyAlignDataTypes>false</VerticallyAlignDataTypes>   <VerticallyAlignJoinConditionWithJoinTable>false</VerticallyAlignJoinConditionWithJoinTable>   <VerticallyAlignListItemComments>true</VerticallyAlignListItemComments>   <VerticallyAlignListItems>true</VerticallyAlignListItems>   <WhereClauseFirstItemBreakType>Never</WhereClauseFirstItemBreakType>   <WrapColumn>120</WrapColumn>   <WrapLongLines>true</WrapLongLines> </LayoutOptions> / comments
  1. Community
  2. SQL Prompt
  3. Formatting an UPDATE query with multiple items in SET phrase
Here's the file I'm using.<?xml version="1.0" encoding="utf-8"?><LayoutOptions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Format.Engine.Forma...
0 votes
Addendum: this error seems to be happening a lot, not just on update queries.  Every time, it's "Sequence contains more than one element." / comments
  1. Community
  2. SQL Prompt
  3. Formatting an UPDATE query with multiple items in SET phrase
Addendum: this error seems to be happening a lot, not just on update queries.  Every time, it's "Sequence contains more than one element."
0 votes
Formatting an UPDATE query with multiple items in SET phrase
  1. Community
  2. SQL Prompt
I'm getting the error below when trying to format a properly-formed UPDATE query that uses a join and then updates more than one column in the SET phrase.  This happens even though the query parses...
2 followers 5 comments 0 votes
I noticed after I had installed SSMS 18.0, then restarted my laptop, a lengthy process of updating SSMS happened on the next boot, during which time it was not possible to run the installer or uninstaller for SQL Prompt.  Once this update completed, I launched SSMS 18.0 and found SQL Prompt installed and partially working (the previous version, which was still installed).  Then I closed that SSMS session, opened my 17.9.1 session and allowed SQL Prompt to update to the latest version.  Now I have SQL Prompt 9.5 working in both SSMS 17.9.1 and 18.0.  It's a little strange for SSMS to choose to install to separate directory by default now, and I suspect that's part of the problem most folks here are experiencing. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt for SSMS 18.0?
I noticed after I had installed SSMS 18.0, then restarted my laptop, a lengthy process of updating SSMS happened on the next boot, during which time it was not possible to run the installer or unin...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2