July 27, 2009 at 1:37 pm
How do I build an expression from this ?
CASE WHEN Cost IS NULL THEN '00000000.00' ELSE
RIGHT( REPLICATE ( '0', 11) +
CAST( CAST ( Cost AS DECIMAL (14,2)) AS VARCHAR ), 11)
Cost comes on a file. In my derived column I want to build an expression to format the cost in '00000000.00'
July 27, 2009 at 1:59 pm
July 27, 2009 at 2:12 pm
Thank you. I still need help with this expression.
July 28, 2009 at 7:45 am
SSIS implements the IF Else construct as:
condition ? [then result] : [else result]
Everything else in your CASE is similar. CAST is done like this:
(DataType)value
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply