Is it not possible to use a view to provide a layer with different names?

Not 100 percent sure what you're trying to do but if you join the table back to itself then you can identify the substitutes that are "Y" for old and...

Cracking good question that! Found some really good stuff here by Paul White explaining temp object caching if anyone is interested...
https://sqlkiwi.blogspot.com/2012/08/temporary-object-caching-explained.html
Cheers, and Happy Christmas all!

Since it's not gold backed anymore it seems you can turn just about anything into money!

If they haven't deprecated it then they definitely should!!

What you need is a guided tour by someone who knows the database and can explain the general principles and the strengths and weaknesses. if you're lucky there is someone...

To learn all you need to do is ask the right questions. This is much harder than it seems. Look at how hard it is to ask a good question...

I don't really use Python.... maybe this is one of the reasons why? Nothing like strong declarative typing.

The keyboard is the most important bit of kit. When you need to type fast it's your best friend! Keyboards on laptops are invariably awful. I use a Dell KB1421...

Nice article, thanks.

In my opinion there's not really any such thing as the "truth" because data changes all the time. The focus should really be on consistency. The...

I completely agree with you Steve. Another very strong case for surrogate keys.