syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

May 2009 Blog Posts

Someone might not understand how CASE works....

    case when StatusFlag = 'LWCA' and TransactionType <> 'W' then 'Layw Cancel'         ELSE     case when StatusFlag = 'LWCA' and TransactionType = 'W' then 'Warranty Cancel'         ELSE     case when StatusFlag = 'WAPK' then 'Warranty Pickup'         ELSE     case when StatusFlag = 'LWSE' and TransactionType <> 'W' then 'Layaway'         ELSE     case when StatusFlag = 'LWSE' and TransactionType = 'W' then 'Warranty Setup'         ELSE     case when StatusFlag = 'SALE' and isnull(HV.QTY,0) > 0 and layawaynumber is null then 'Sale'         ELSE     case when StatusFlag = 'SALE' and isnull(HV.QTY,0) > 0 and NOT layawaynumber is null then 'Lwy Pickup'    ...

posted @ Tuesday, May 05, 2009 9:35 AM | Feedback (2) |

Powered by:
Powered By Subtext Powered By ASP.NET