SqlZim questions

SqlZim answers

• Count how many orders were shared between customers
• How to rename column before unpivot? SQL Server
• Get the latest value for each column
• Query on large table using DateTime WHERE clause
• How can I add an autoincrementing ID field to a table in SQL-SERVER starting from X
• MS sql server 2014 select dynamic pivot with lag using last known value for the pivoted column
• MERGE with DELETE on target with partial match on source?
• SQL Update Join Multiple Tables (if field exists)
• Double loop with drop table in MSSQL
• MSSQL Procedure - Performance considerations when updating a massive table