Baka SQL Tricks are Stupid SQL Tricks. These posts are about doing things with T-SQL that show that even a language not designed for a task can sometimes still achieve that task, if you are creative. For example, SQL is not a math programming language, and its math-related functionality is quite minimal, so I'm solving various math problems from Project Euler, or others I think of myself. It can be challenging to come up with a solution that works in SQL, when in another language it may be a one- or two-line answer. Or maybe I'll implement some datatypes that I liked from Python. If I come up with a way to generate a GUI in SQL, you'll see it here (it'll never happen).
Project Euler Problem 10 - Mar 30, 2014 1:58:28 PM
Project Euler Problem 2 - Apr 04, 2014 11:23:23 PM
1000th Fibonacci Number - Apr 12, 2014 2:23:36 PM
Project Euler Problem 1 - Apr 14, 2014 10:54:51 PM
Project Euler Problem 3 - Apr 19, 2014 12:20:55 AM
Weird SQL Server bug - Apr 21, 2014 11:57:42 PM
SQL Server Lists Preview 1 - Apr 23, 2014 1:12:25 AM
Project Euler Problem 8 - Apr 26, 2014 12:25:13 AM
Project Euler Problem 4 - Apr 28, 2014 12:15:11 AM
Project Euler Problem 6 - May 06, 2014 11:22:18 AM
SQL Server Lists Preview 2 - May 08, 2014 12:57:57 AM
Project Euler Problem 10 (Sieve of Eratosthenes version) - May 09, 2014 11:24:36 AM
Project Euler Problem 5 - May 10, 2014 2:24:44 PM
Project Euler Problem 14 - May 12, 2014 11:34:11 PM
Project Euler Problem 7 - May 16, 2014 11:39:42 PM
Project Euler Problem 9 - May 21, 2014 10:43:28 AM
Project Euler Problem 12 - May 23, 2014 1:9:41 AM
SQL Server Lists Preview 3 - May 24, 2014 12:58:5 AM
SQL Server Lists Release - May 24, 2014 1:15:38 AM
Project Euler Problem 11 - May 26, 2014 2:57:35 PM
Project Euler Problem 13 - May 28, 2014 12:15:47 AM
Project Euler Problem 15 - May 29, 2014 12:19:55 AM
Project Euler Problem 16 - May 31, 2014 1:19:31 AM
Project Euler Problem 17 - Jun 04, 2014 12:31:10 AM
Project Euler Problem 18 and Problem 67 - Jun 05, 2014 12:51:2 AM
Project Euler Problem 19 - Jun 06, 2014 12:55:46 AM
Project Euler Problem 20 - Jun 07, 2014 1:13:11 AM
Project Euler Problem 21 - Jun 08, 2014 3:43:45 PM
Project Euler Problem 22 - Jun 11, 2014 12:28:59 AM
Project Euler Problem 23 - Jun 18, 2014 1:20:20 AM
Project Euler Problem 24 - Jun 19, 2014 12:49:53 AM
Project Euler Problem 25 - Jun 26, 2014 1:5:37 AM
Project Euler Problem 26 - Jun 26, 2014 11:58:3 PM
Project Euler Problem 27 - Jun 28, 2014 1:13:55 AM
Project Euler Problem 28 - Jul 03, 2014 1:15:13 AM
Project Euler Problem 29 - Jul 09, 2014 12:52:34 AM
Project Euler Problem 30 - Jul 13, 2014 2:38:9 PM
Project Euler Problem 31 - Jul 16, 2014 12:30:48 AM
Project Euler Problem 32 - Jul 24, 2014 12:22:8 AM
Project Euler Problem 33 - Jul 26, 2014 11:24:49 PM
Project Euler Problem 34 - Jul 29, 2014 1:1:50 AM
Project Euler Problem 35 - Aug 03, 2014 9:32:10 PM
Project Euler Problem 36 - Aug 05, 2014 1:15:15 AM
Project Euler Problem 37 - Aug 08, 2014 12:38:59 AM
Project Euler Problem 38 - Aug 09, 2014 10:20:25 PM
Project Euler Problem 39 - Aug 20, 2014 12:39:27 AM
Project Euler Problem 40 - Aug 23, 2014 1:1:38 AM
Project Euler Problem 41 - Aug 26, 2014 12:51:18 AM
Project Euler Problem 42 - Sep 04, 2014 12:28:33 AM
Project Euler Problem 43 - Sep 11, 2014 12:39:22 AM
Project Euler Problem 44 - Sep 14, 2014 10:11:11 PM
Project Euler Problem 45 - Sep 25, 2014 12:0:12 AM
Project Euler Problem 46 - Sep 29, 2014 11:55:37 PM
Project Euler Problem 47 - Oct 02, 2014 11:28:54 PM
Project Euler Problem 48 - Oct 18, 2014 12:2:58 AM
Project Euler Problem 49 - Oct 23, 2014 12:23:7 AM
Project Euler Problem 50 - Oct 28, 2014 11:53:47 PM
Project Euler Problem 51 - Nov 04, 2014 1:32:59 AM
Project Euler Problem 52 - Nov 08, 2014 12:19:4 AM
Running Python scripts from T-SQL code (using the CLR) - Nov 09, 2014 6:1:29 PM
Project Euler Problem 53 - Nov 16, 2014 11:21:23 PM
Project Euler Problem 54 - Nov 19, 2014 1:15:35 AM
Project Euler Problem 55 - Dec 02, 2014 1:36:19 AM
Project Euler Problem 56 - Dec 07, 2014 1:25:39 AM
Project Euler Problem 57 - Dec 09, 2014 1:26:6 AM
Project Euler Problem 58 - Dec 17, 2014 2:19:57 AM
Project Euler Problem 59 - Dec 19, 2014 1:9:12 AM
Project Euler Problem 60 - Dec 31, 2014 1:31:36 AM
Project Euler Problem 61 - Jan 11, 2015 12:48:15 AM
Project Euler Problem 62 - Jan 17, 2015 11:5:54 PM
Project Euler Problem 63 - Jan 27, 2015 1:56:8 AM
Project Euler Problem 64 - Feb 08, 2015 3:37:30 AM
Project Euler Problem 65 - Feb 20, 2015 1:0:58 AM
Project Euler Problem 66 - Mar 12, 2015 11:56:5 PM
Project Euler Problem 68 - Mar 18, 2015 12:22:1 AM
Project Euler Problem 69 - Apr 11, 2015 11:39:38 PM
Project Euler Problem 70 - Apr 13, 2015 11:26:7 PM
Project Euler Problem 71 - Apr 19, 2015 1:3:57 AM
Project Euler Problem 72 - Apr 26, 2015 9:11:8 PM
Project Euler Problem 73 - May 09, 2015 10:29:25 PM
Project Euler Problem 74 - Jul 11, 2015 3:36:38 PM
Project Euler Problem 75 - Jul 19, 2015 1:22:12 AM
Project Euler Problem 76 - Jul 26, 2015 7:8:0 PM
Project Euler Problem 77 - Aug 02, 2015 4:41:16 PM
Project Euler Problem 78 - Aug 10, 2015 1:2:13 AM
Project Euler Problem 79 - Dec 13, 2015 1:3:5 AM
Project Euler Problem 80 - Sep 04, 2016 1:10:51 PM
Project Euler Problem 81 - Sep 18, 2016 2:7:41 PM
Project Euler Problem 82 - Sep 25, 2016 2:6:30 PM
Project Euler Problem 83 - Oct 02, 2016 2:32:15 PM
Project Euler Problem 84 - Oct 09, 2016 1:8:0 PM
Project Euler Problem 85 - Oct 16, 2016 1:53:9 PM
Project Euler Problem 86 - Dec 25, 2016 2:27:43 PM
Project Euler Problem 87 - Jan 01, 2017 3:8:47 PM
Project Euler Problem 88 - Feb 05, 2017 1:55:59 PM
Project Euler Problem 89 - Feb 26, 2017 3:26:59 PM
Project Euler Problem 90 - Mar 12, 2017 1:55:53 PM
Project Euler Problem 91 #1 - Jun 04, 2017 12:27:40 PM
Project Euler Problem 91 #2 - Jun 04, 2017 12:29:41 PM
Project Euler Problem 91 #3 - Jun 04, 2017 12:32:20 PM
Project Euler Problem 92 - Jul 16, 2017 11:41:41 AM
Project Euler Problem 93 - Jan 07, 2018 6:9:32 PM
Bridge to Hades - Feb 03, 2018 3:46:46 AM
Project Euler Problem 94 - Apr 29, 2018 2:16:3 PM
Project Euler Problem 95 - Jun 10, 2018 12:6:42 PM
Project Euler Problem 96 - Aug 19, 2018 1:50:2 PM
Project Euler Problem 97 - Oct 07, 2018 1:32:26 PM
Project Euler Problem 98 - Nov 04, 2018 1:45:21 PM
Project Euler Problem 99 - Jan 13, 2019 3:26:55 PM
Project Euler Problem 100 (Final) - Jan 20, 2019 1:34:1 AM