SqlZim questions

SqlZim answers

• SQL Partition By alternating groups of rows
• SQL REPLACE not working as expected
• sub query within coalesce
• SQL Server concatenation separated by comma only when column is not null
• SQL Server get latest value by date
• Query to identify if current SQL Server version supports columnstore indexes
• ORDER BY in SQL Server vs Postgresql
• SQL - Selecting employees that have ended most recent contract but have other contracts open
• PATINDEX with letter range exclude diacritics (accented characters)
• Error Inserting Data into tables in SQL Server