etliens questions

etliens answers

• Calculate Distinct count when joining two tables
• SQL Select FOR XML into Solr document
• How to avoid using duplicate savepoint names in nested transactions in nested stored procs?
• Combine XML from T-SQL
• SQL try-catch statement not handling error (SQL Server 2008)
• insert char into string at multiple positions sql
• How do to the opposite of "row_number() over (partition by [Col] order by [Col])"
• Which SQL command can I use to see the structure of a table on SQL Server?
• How can I manage SQL Server jobs using a Database project