|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/31/2008 12:48:22 AM
Posts: 1,
Visits: 2
|
|
CASE WHEN TO.PRODUCT = 'Bag'
THEN (
CASE WHEN CP.TO_sale_TYPE = 'DYNAMIC'
THEN 'Sell'
WHEN CP.TO_sale_TYPE = 'STATIC'
THEN 'Sell-s'
ELSE 'Sell-UNKNOWN' END
)
CASE WHEN From.PRODUCT = 'Bag'
THEN (
CASE WHEN CP.From_sale_TYPE = 'DYNAMIC'
THEN 'Sell'
WHEN CP.From_sale_TYPE = 'STATIC'
THEN 'Sell-s'
ELSE 'Sell-UNKNOWN' END
)
Could these two case statements be combined using an 'In' or any other options could be done?
Hasan
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/8/2008 5:25:30 AM
Posts: 8,
Visits: 6
|
|
Try this....
CASE
WHEN TO.PRODUCT = 'Bag' AND From.PRODUCT = 'Bag'
THEN
(
CASE
WHEN CP.TO_sale_TYPE = 'DYNAMIC' AND CP.From_sale_TYPE = 'DYNAMIC'
THEN 'Sell'
WHEN CP.TO_sale_TYPE = 'STATIC' AND CP.From_sale_TYPE = 'STATIC'
THEN 'Sell-s'
ELSE
'Sell-UNKNOWN'
END
)
END
|
|
|
|