On 29 Sep 2010, at 5:34pm, Andy Chambers wrote: > I've got a nice normalized table and need to produce a de-normalized > view of this table (i.e. convert it > from tall skinny, into wide short table).
SQL (not just SQLite) is traditionally terribly bad at doing matrix inversions. What do you want to use the wide short table for ? Does it really need to exist as a table ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
