ErikE

ErikE has asked 46 questions and find answers to 178 problems.

Stats

About

SQL Fiend.

Puzzle Lover.

Curious about almost everything.

ErikE questions

Iterable collection that can be mutated during iteration
MySql: Operate on Many Rows Using Long List of Composite PKs
Serialize anonymous type with literal JSON properties
Symbols loaded, but still can't step into .Net source
C# Override Method at Runtime
"Server.CreateObject Failed" on COM+ component creation from classic ASP on IIS 7
Expressing 2x2 Logic Grid in Code Efficiently
Mock dynamic require in Node with Jest
Allow derived type cast as parent type to return `object`, but using the derived type's method
Can a Java Collectors.groupingBy return a Stream as its list of grouped items?

ErikE answers

Select same column from multiple tables only WHERE something = something
TSQL counting how many occurrences on each day
How to create multiple rows from a single row - normalize a table
Duplicated results when performing INNER JOIN
Procedures using IDENTITY column fail with primary key violation after restoring sql 2000 backup onto sql 2008
SQL Server BETWEEN
How to convert string to number and vice versa in Excel
How to JOIN two tables with one mandatory condition and an optional one
Why does datepicker() accept the argument 'getDate'?
Trying to open a file dialog using the new IFileDialog and IFileOpenDialog interfaces in C# with minimal code [duplicate]