Where not Exists - why is this working the way it does...
In short - I have Dimension table with Aircraft ID's, that is not complete. What the code does, is read the Fact table as well, takes the ID's that are missing from the Dimension table, and concatenates it.
It works fine. LOL. I guess no one posts here if stuff works.
My question is - the solution contains a temp table. I'm thinking that it should work, without the temp table as well?
Can someone explain to me - why cant I do it without a temp table.