select case change 2 column values

I am using the below SQL sytax to add a dummy column and move vales to that column.
SELECT        ID, WO_Number, ItemID, QtyUsed, Units, Feet, CASE WHEN Feet > 0 THEN Feet ELSE QtyUsed END AS QtyUsed2
FROM            TRX_ROW_INV_DRI

what also need to do is that when Feet > 0, also move Units to another dummy column 'Units2' and then change the value to 'FT'.

Any idea on how to accomplish this?
LVL 1
vwallaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
somethnig like this?

SELECT        ID, WO_Number, ItemID, QtyUsed, case when feet > 0 then 'Ft' else units end as Units, Feet, CASE WHEN Feet > 0 THEN Feet ELSE QtyUsed END AS QtyUsed2, case when feet > 0 then units end as units2
FROM            TRX_ROW_INV_DRI
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vwallaAuthor Commented:
Got.  It was easier than I thought.

SELECT        ID, WO_Number, ItemID, QtyUsed, Units, Feet, CASE WHEN Feet > 0 THEN Feet ELSE QtyUsed END AS QtyUsed2,
                         CASE WHEN Feet > 0 THEN 'FT' ELSE Units END AS Units2
FROM            TRX_ROW_INV_DRI
0
vwallaAuthor Commented:
We posted at the same time, but you were quicker! Thanks!
0
gplanaCommented:
Not sure if I fully understood your question, but you can execute this select:

SELECT        ID, WO_Number, ItemID, QtyUsed, Units, Feet, CASE WHEN Feet > 0 THEN Feet ELSE QtyUsed END AS QtyUsed2, CASE WHEN Feet > 0 THEN Units ELSE NULL END AS Units2
FROM            TRX_ROW_INV_DRI

What do you mean about change the value to FT ?
0
sdstuberCommented:
your conditions don't seem to correspond to your explanation.


>>>>>  when Feet > 0, also move Units to another dummy column 'Units2' and then change the value to 'FT'.

>>CASE WHEN Feet > 0 THEN 'FT' ELSE Units END AS Units2

This will move units to unit2 when feet <= 0  or when feet is null

is that really what you want?


in any case,  it seems you're on the right track,  just make sure your > and < are correct.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.