I've recently answered a T-SQL question over on Stackoverflow. Unfortunately, I've answered it a long time after it was published, so I'm not even sure if the OP have seen my answer.
This question has a very low view rating (45 views at this time) and I'm wondering about other ways to solve the OP's problem. I'm pretty sure my suggestion will solve the problem, but since it uses DDL triggers (which I have no real-world experience with), I'm wondering is there a better way. So, what do you think? have any suggestions?
I have two datasets:
- one is data about dogs [my data]
- the second is a lookup table of matching keys [I have no control over this data]
The matching keys are updated regularly, and I want to create a View (or something that fulfills the same purpose) of the Dog…