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,750 of 19,505 |
| Plamen Ratchev to All |
| Re: Return valuse based on multiple "if |
| 06 Feb 10 22:23:33 |
0c7c77a5 From: Plamen@SQLStudio.com The CASE expression does mapping of the sources to sort values, in a way giving priority to 1, then 2, 3, etc. That way the source with sort value 1 (Tiger) is on top of the list if any entries exist. If not then the next one. -- 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