Search results
-
Case statement not working
The column data are Int. I try your propulsive and it works. Thank you- Makis Best
- Post #3
- Forum: SQL Server Scripts and Tools
-
Case statement not working
Hi all I have this Case statement but seems not working, can anyone help with the script? Select LItmSale.name, CASE LItmSale.LinkID WHEN 001 THEN (SELECT Price FROM ItemPrc WHERE PriceListAA = 39 AND PriceCtgr = 'Team1' AND ServiceID = 100.001) WHEN 002 THEN (SELECT Price FROM...- Makis Best
- Thread
- Replies: 2
- Forum: SQL Server Scripts and Tools
-