Hi,
I’ve been able to get most of the formatting the way I want. But, there are two things that ae in conflict with the current configuration options. As far as I can tell there is only one White Space setting dealing with commas. It would be nice if there were two settings, an additional one for Lists.
Currently, I have the white space “around commas” set to Once Space After and that works great for general formatting when dealing with functions. In this example it puts one space after the commas:
string_agg(convert(nvarchar(max), foo_id), N'; ') within group (order by foo_id) as foo_id_list
But, when it comes to Lists (like a select list) it also put a space after the comma. For example:
select foo , foo1 , foo2
My request is to keep the white space setting as is for “non-list” items and add a new option for lists (select, group by, etc.). So, for example the select list could be like:
select foo ,foo1 ,foo2
I realize it’s not too hard to fix this up post-format, but it would be a nice option.
Thanks!
Hi Lamprey, thanks for this idea. I have to think about how to introduce this idea without confusing users with too many options.
Give me some time please
Regards
Guido