Project Euler problem 2 T-SQL

May 26

Euler problem 2: By considering the terms in the Fibonacci sequence whose values do not exceed four million, find the sum of the even-valued terms. This is a sort of running sum problem that used to be hard (before T-SQL in SQL server 2012) I solved it with known math formula and recursion with common table expression. Tomas as usual solved with single-statement...

Read More

Project Euler with T-SQL

May 26

Me and colleague in my current Project Tomas Eriksson  decided to start to try the Project Euler problemes in Microsoft SQL Servers  Language Transact SQL (T-SQL). First problem was: Add all the natural numbers below one thousand that are multiples of 3 or 5. I made my solution hack back in 2008. It has some flaws. But I post it here to invite criticism. ( Yes I...

Read More