Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.ms-sqlserver | Notorious Rube Goldberg contraption | 19,505 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 17,749 of 19,505 |
| Plamen Ratchev to All |
| Re: Return valuse based on multiple "if |
| 06 Feb 10 18:51:28 |
87bbba04
From: Plamen@SQLStudio.com
SELECT TOP 1 WITH TIES source, price, state
FROM #TempTable
WHERE source IN ('Tiger', 'Ape', 'Elephant')
ORDER BY CASE source
WHEN 'Tiger' THEN 1
WHEN 'Ape' THEN 2
WHEN 'Elephant' THEN 3
END;
--
Plamen Ratchev
http://www.SQLStudio.com
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
(c) 1994, bbs@darkrealms.ca