Need help in A SQL Query

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

My table structure is

Particulars    col1          col2
aaa             10           null
bb              20           null
ccc            null           70
dd              50           null
ee             null           20
ff             null           60

one of the column from col1 and col2 can contain value, another remain null.
Now I want an out put like this

Particulars    Amount
aaa             10  
bb              20  
ccc             70
dd              50
ee              20
ff              60

What will be the query?
Please help.

Posted 19-Aug-12 9:32am

Sourav Sarkar-SS

Add a Solution

Comments

ridoy 19-Aug-12 16:41pm

Do you try anything or where is your code?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2012-08-19T10:10:00

Solution 1

Coalesce lets you specify a second column to get a value from, if the first is null. Your data format looks a bit stupid, but it's easy to write the SQL to select it.

select particulars, coalesce(column1, column2) as myval from mytable

I know from experience that you have paying customers, yet you are asking the most basic questions and refuse to do any research or try to do your work. You really should stop taking people's money, it's basically fraud.

Posted 19-Aug-12 10:10am

Christian Graus

Comments

[no name] 19-Aug-12 16:23pm

and the code is returning value like

Collapse | Copy Code

Particulars Amount
aaa 10
bb 20
ccc 0
dd 50
ee 0
ff 0

Christian Graus 19-Aug-12 16:23pm

I help because I like it. Even when people are rude to me :-)

Sergey Alexandrovich Kryukov 19-Aug-12 23:29pm

Rudeness is unpleasant, but the helping is hard to stop, right? :-)
A 5.
--SA

Christian Graus 19-Aug-12 16:24pm

http://msdn.microsoft.com/en-us/library/ms190349.aspx - the documentation says that coalesce returns the first non null values, and it should. If col1 is 0, it will return 0. If it is null, it will return the value in col2.

[no name] 19-Aug-12 16:36pm

Done success.

[no name] 19-Aug-12 16:37pm

my +5.
I accept the solution as well.

Thanks.

[no name] 19-Aug-12 16:45pm

say something
Please!

Christian Graus 19-Aug-12 17:25pm

LOL - I went out for a bit. I'm glad it worked for you.

[no name] 21-Aug-12 14:54pm

Thank you so much.
and sorry for everything.
I wish best of luck.

[no name] 21-Aug-12 14:55pm

thanks a lot.
and sorry for everything

ridoy 19-Aug-12 16:51pm

right answer..+5