Coder's Revolution

Do you want a revolution?

Blog Archives - 4 Record(s)

Year: '2009' - Month: '8'

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

SQL
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.
3

ColdFusion UDF: Calculate A Number's Divisors

ColdFusion, Mathmatics, Performance
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.
0

Calculate Prime Numbers: Sieve of Eratosthenes

ColdFusion, Mathmatics, Performance
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 cflib.org, but I thought I could do it in less code, so I dug in myself.
4

Bit By ANSI_NULLS- Are Your Nulls Antsy Too?

SQL
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
0