EricZ

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

Stats

About

EricZ questions

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

EricZ answers

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
Merging/extending records with identical type in SQL Server
Ignore Foreign Key constraints in batch insert