Blog Archives - 4 Record(s)

Remove Filter Year: '2009' - Month: '8'

SQL Server 2000 NULL Bug When Left Outer Joining A Nested View

Posted by Brad Wood
Aug 21, 2009 08:37:00 UTC
I found a very interesting behavior today with SQL Server 2000 SP4 that I'm most certain is a bug. I Googled for a while and found a couple old threads bringing up similar issues but they were without confirmation nor resolution. My actual use case was fairly complicated and confusing. I thought long and hard and came up with a simple example of the problem that still made a shred of sense.

ColdFusion UDF: Calculate A Number's Divisors

Posted by Brad Wood
Aug 15, 2009 06:24:00 UTC
Here's another UDF I was tinkering with last week. I wanted to be able to count all of the numbers that divided evenly into a given integer. I couldn't find a ColdFusion implementation, so after getting some advice from Stack Overflow I created my own.

Calculate Prime Numbers: Sieve of Eratosthenes

Posted by Brad Wood
Aug 14, 2009 06:34:00 UTC
Ahh... the quintessential math problem-- finding prime numbers. Last week while tinkering with a math challenge I needed to find all of the primes up to a given number. There was a version on, but I thought I could do it in less code, so I dug in myself.

Bit By ANSI_NULLS- Are Your Nulls Antsy Too?

Posted by Brad Wood
Aug 05, 2009 07:39:00 UTC
I had one of those (all-too common) moments today that I spent scratching my head at a page of SQL code that was failing for no apparent reason. What's worse is the EXACT same code worked in another window. After a good deal of poking and prodding I figured out what was wrong and it involved my ANSI_NULLS setting

Site Updates

Entries Search