Order in the SQL Court

It's almost 4:00 a.m. on March 22nd, 2009, and it's almost quiting time. I have really outdone myself today. Please see my FindItByMe BLOG later to see how the web site is developing. I found out that you can't use an order by clause in a multi-statement table valued function in SQL 2008. But...there is a way around it. You can use an order by clause in the select statement of an inline table valued function IF you use a TOP clause on the select. Who knows why, but it works.

Anyway, it all has to do with a self-referential search system I'm developing. So the system will drill down properly no matter what the context of the initial search is. And it is all multi-lingual. Although a word can have multiple synonyms in any language, I have a weighting system that assigns the most frequently used synonym more weight. Then the system always chooses the one synonym in the target language with the highest weight value. I still have to do the clarifier engine to allow multiple choices to synonyms, but this will be done on freetext search only for now.

Ok...time to sleep. Later!