Avatar of 1jaws
1jaws
Flag for United States of America asked on

so simple sql query

On select statement

if o.OrderID is not null
       '$' + convert(varchar, convert(money, inv.price * -1), 1) as amount
       else
       '$' + convert(varchar, convert(money, inv.price), 1) as amount

how can I write this logic  on tsql query?.
C#Microsoft SQL Server 2008SQL

Avatar of undefined
Last Comment
1jaws

8/22/2022 - Mon
SOLUTION
ukerandi

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
1jaws

ASKER
I've requested that this question be deleted for the following reason:

dont need it
ukerandi

i alrdeay shown example,how to do the logic in t-SQL, through that any one can understand how to process the logic in T-SQL.
ukerandi

i alrdeay shown example,how to do the logic in t-SQL, through that any one can understand how to process the logic in T-SQL.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Anuradha Goli

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
1jaws

ASKER
Sorry ukerandi, I didn't see your answer when I hit delete button. Thanks both for the answer.