Show Aggregate Result

ccparkhill

Great new feature but can we please also have distinct count?

Also, all I seem to be able to get with dates is a count, distinct count, min and max would also be useful.

Dan_J

Hi @ccparkhill

Thanks for reaching out to us regarding this.

I'm glad the new aggregate values feature is useful, however I appreciate being able to have distinct count would also be a good feature. I've escalated this to our development team for their consideration and will come back to you again as soon as I have heard back from them.

Dan_J

Hi @ccparkhill

Following my previous message, I'm pleased to advise that distinct count has now also been added to SQL Prompt. You can download the latest version of SQL Prompt here: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-16-release-notes

I hope this helps!

ccparkhill

Thanks @Dan_J, very useful. It would be nice to see min/max on date columns too.