Old posts good, new posts bad.

Like in from May '08 to June '09?

It's OK. I think I've figured out the answer myself:

create view dbo.xml_schemas

as

select t5.xml_collection_id

, collection_name = t5.name

, schema_id

,...

This reminds me of a function I had to write recently, to convert alphanumeric keys to numeric keys.  The company had char(8) keys as '3AJPUL68' and desired to map the alphanumeric space...