Anton Grig questions

Anton Grig answers

• GROUP BY and create columns for each unique value grouped on (output as 1 row always), then use the output as a JOIN - SQL Server
• What is the difference between using `IF @@TRANCOUNT > 0` vs `XACT_ABORT` approach to rollback transaction? When do I use either of this approach?
• SQL ROLLUP with COALESCE
• Trim Intermediate spaces in a string in Postgres