Query #1.4: Since we only need 1 row from the Query #1.3's output, we remove all duplicated rows using SELECT DISTINCT Statement We calculate the dates for the first day of this and next year using ...

Steps to reproduce This is included in a complex project that is being migrated from Linq-To-SQL so it would be a bit hard to provide code samples for the issue. The example linq that generates the ...