I have a Table that contains Columns A & B
I need to Check Column A and if it does not equal a designated fix value then add a new record using the designated fixed Value for Column A and existing Value for Column B
Can you combine VALUES & SELECT into a INSERT Statement or another way to accomplish this?