sql server - Can you have if-then-else logic in SQL? - Stack Overflow

I need to do select data from a table based on some kind of priority like so: select product, price from table1 where project = 1 -- pseudo: if no price found, do this: select product, price from ... With SQL server you can just use a CTE instead of IF/TH

stackoverflow.com