|
4>
5> CREATE TABLE #ProductPrices (
6> ProductName VarChar(25),
7> SuperSalePrice Money NULL,
8> SalePrice Money NULL,
9> ListPrice Money NULL)
10> GO
1>
2> SELECT ProductName, COALESCE(SuperSalePrice, SalePrice, ListPrice) AS CurrentPrice
3> FROM #ProductPrices
4> GO
ProductName CurrentPrice
------------------------- ---------------------
(0 rows affected)
1>
2> drop table #ProductPrices;
3> GO
|