It works in 2005, no dublicates, but i guess that isnt a surprise. I find it scary though, that TOP 100 PERCENT actually affects the query plan ... isnt that a bug in it self?
-- The Heisenberg uncertainty principle also applies when debugging
Sorry I hadnt read that tread before, or I would have tested it earlier. The bright side of it is that you can now answer Arnold, your original approach is portable between 2000 and 2005, and his isnt
-- The Heisenberg uncertainty principle also applies when debugging
Generating Random String
Posted - 09/19/2006 : 17:59:46
