Anon questions

Anon answers

• Converting ntext / text to hex / binary / varbinary
• How to count business days from a given date in SQL Server using a calendar reference table
• How to simulate COALESCE conditions in WHERE clause
• SQL Server : Consecutive Rows Issue
• How to self-join table in a way that every record is joined with the "previous" record?
• Change only time part of a datetimeoffset in SQL
• skip first row in read of Excel file
• Denormalized access: views or materialized tables?
• What's a zip join? Have you ever heard of that, or a pairwise join?
• openrowset for excel: can we skip several rows?