Anon questions

Anon answers

• Counting multiple fields in SQL
• Insert results from Stored Procedure into table and add an extra column
• Get DateTime corresponding to last Thu or Fri or Mon etc in SQL Server 2012
• Replace a certain part of the date
• WITH ROLLUP GRAND TOTAL AND SUBTOTAL
• 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?