EricZ

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

Stats

About

EricZ questions

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

EricZ answers

How to find duplicate entries with different values in one column SQL Server 2008 R2
SQL to SUM certain rows only
Selecting based on many to many filter
T-SQL | Find multiples (with a twist?!)
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