> --- In [email protected], Thomas Steinmaurer<ts@...> wrote: >> Is your question theoretical for some kind of case study or DBMS >> comparison thingy or did you hit a limit already? Just curious. ;-) > > In really, is a practical question. > > I have to classify some records (about 300k) in many categories (nearly 200). > So, I thought do this directly in the select statement (using case clause). > However, write a query with 200 conditions "when ... then..." to, at the end, > the debugger tell you that you reached the conditions limits is kind annoying.
I would rather create a mapping/lookup table and join the two tables. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
