CMOS sensors are faster and cheaper to produce, that's why Canon is able to have full frame DSLRs (e.g. Canon 1Ds Mark II, which has a sensor size =35mm film, but costs >S$10k for body only!!!), while Nikon has yet to come out with a full frame DSLR.
To me, CCD and CMOS doesn't really matter...