EricZ

EricZ has asked 2 questions and find answers to 23 problems.

Stats

About

EricZ questions

How to get distinct dependency list from CTE
How to COUNT DISTINCT on more than one column

EricZ answers

SQL Server : find duplicates in a table based on values in a single column
What's wrong this T-SQL statement?
Creating calculated fields in sql
Common Table Expression With Insert and Delete
How can I generate a hierarchy path in SQL that leads to a given node?
Grouping by MONTH in SQL
Merging/extending records with identical type in SQL Server
Ignore Foreign Key constraints in batch insert
Odd error using IF/ELSE IF statements
How to check existence of a table from a different sql db?