SqlZim questions

SqlZim answers

• How can I loop through a table within a stored procedure?
• SQL to show 1 for unique and 0 for reapeat
• why char(13)+char(10) in for xml path('') does not work?
• SQL Server (T-SQL): Avoid call scalar function multiple times
• WHERE and WHERE NOT in SELECT
• SQL Select column with maximum value in another column
• 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