InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:30:34 GMT20http://www.sqlservercentral.com/Forums/Topic1391820-338-1.aspx[quote][b]anthony.green (12/3/2012)[/b][hr]It hits the first true condition then terminates the case statement.[/quote]Thank you - I did feel this was the case but the data does not reflect the logic!?Will now dig deeper.Thank youMon, 03 Dec 2012 03:43:14 GMTSteveEClarkehttp://www.sqlservercentral.com/Forums/Topic1391820-338-1.aspxIt hits the first true condition then terminates the case statement.Mon, 03 Dec 2012 03:41:09 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1391820-338-1.aspx[quote][b]Eugene Elutin (12/3/2012)[/b][hr][quote]... does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions? [/quote]That is correct.[/quote]Sorry;My question is; Do I understand the CASE logic correctly and does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions? OR Does it do EVERY CASE WHEN check and hold the last one as the description ?So if I put an initial check in saying ... CASE StockCode like 'Stock%' Then 'Yippee'ALL Records would fall into this and no other categories would be highlighted.Mon, 03 Dec 2012 03:39:24 GMTSteveEClarkehttp://www.sqlservercentral.com/Forums/Topic1391820-338-1.aspx[quote]... does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions? [/quote]That is correct.Mon, 03 Dec 2012 03:35:52 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1391820-338-1.aspxHi Guys,I am having a few issues with some code and wanted some guidance ;I am creating a view based on a table, and need to create a "Identify" column, based on the data in the table ;Simple - 3 columnsStockCode, MorB, WarehouseStockA,M,AAStockB,B,AAStockC,B,BBStockD,B,CCStockE,M,BBMy Logic;SelectStockCode, MoRB, ,Warehouse,CASE WHEN Warehouse = 'CC' then 'Cars' WHEN MorB = 'B' then 'Bought' WHEN Warehouse = 'AA' then 'Available' ELSE 'xxx'ENDas StockCategoryReseult:I would hope to see the following;StockD,B,CC,'Cars'StockB,B,AA,'Bought'StockA,M,AA,'Available'StockC,B,BB,'xxx'StockE,M,BB,'xxx'My question is; Do I understand the CASE logic correctly and does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions? or does it do EVERY CASE WHEN check and hold the last one as the description ?Mon, 03 Dec 2012 02:55:20 GMTSteveEClarke