SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in COUNT(ALL|DISTINCT [column]) breaks 'align aliases' option      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic COUNT(ALL|DISTINCT [column]) breaks 'align aliases' option Author Message Mindflux Joined: 25 May 2013 Posts: 846 Country: United States COUNT(ALL|DISTINCT [column]) breaks 'align aliases' option It seems having either keyword in the COUNT function breaks alignment of alias names for those columns with aliases. Is there an easy fix for this one? Good alignment (although not perfect, the top convert statement alias isn't aligned): Code: SELECT CONVERT(VARCHAR(16) ,ar.RunStartDate ,1) AS StartDate       ,COUNT(ars.TestNum)              AS DailyCount       ,SUM(COUNT(ars.TestNum)) OVER()  AS SumOfTests Bad: Code: SELECT CONVERT(VARCHAR(16) ,ar.RunStartDate ,1) AS StartDate       ,COUNT(DISTINCTars.TestNum)  AS DailyCount       ,SUM(COUNT(DISTINCT ars.TestNum)) OVER() AS SumOfTests Thu May 31, 2018 4:22 pm Mindflux Joined: 25 May 2013 Posts: 846 Country: United States Setting "Name Length for Alignment" to 0 fixed this. The default was 40. Thu May 31, 2018 5:14 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.