How can we help you today? How can we help you today?

Show Aggregate Result

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.
ccparkhill
0

Comments

3 comments

Sort by
  • 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
    0
  • 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!
    Dan_J
    0
  • ccparkhill
    Thanks @Dan_J, very useful. It would be nice to see min/max on date columns too.
    ccparkhill
    0

Add comment

Please sign in to leave a comment.