1. You know it’s time to ask for help when SQL Server keeps telling you that more and more columns are either not part of a group clause or an aggregate function
2. There’s a stored procedure that is the equivalent of DESCRIBE in mysql for mssql called sp_columns and it gives you more information than you could ever need
3. Related to #1, chances are you’re trying to de-duplicate data without using or accounting for a way of capturing data that already exists
Thank you for reading. Please let me know if there are any clarifications I can make or further questions I can answer either down in the comments, on LinkedIn, or hit me up on Mastodon.
