I am a SQL Server professional with over 30 years of experience in data modeling, SQL Server coding and internals, and ETL.
I’ve been part of the SQL Server community for many years, as a speaker and writer, and have an equally long-standing enthusiasm for Dollywood and DisneyWorld, as a self-confessed roller coaster addict.
GROUP BY clauses is a very common, but tedious, activity for a SQL programmer. SQL Prompt will fill it in for you, with all non-aggregated columns returned by the query. Read more