Adding blank column in View

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi!

I have a view which I want to add a new column. This view I am creating, the data in the view is from two views (tableA and tableB). Let's just say tableC is my new view. I want the last column(column5) in my tableC in this condition:

For each data in TableC
if column2 of TableA <= column3 of TableB then column3 in tableC = 1
else column3 in tableC = 0
End For Each

Could this be possible? It is okay for me to create a new table. Just the last column should be in that condition stated above.

I am a newbie in SQL. Usually doing front-end, so I am new with all the terms in SQL.
I will be so blessed if some of you can help. Thanks.

Feel free to comment below for further instructions.

Posted 30-Jun-14 23:08pm

mitchiee1226

Add a Solution

2 solutions

Solution 2

Hi,

focusing on your condition, try below sql statement

SQL

CASE WHEN TABLEa.COL2 <= TABLEb.COL3 THEN TABLEc.COL3=1 ELSE  TABLEc.COL3=0 END

Hope this will help you.

Cheers

Posted 30-Jun-14 23:44pm

Magic Wonder

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)

Shameel · Accepted Answer · 2014-06-30T23:41:00

Solution 1

Just out of mind, not tested.

SQL

SELECT 
    CASE WHEN TableA.Column2 <= TableB.Colum3 THEN 1 ELSE 0 END AS Column3
FROM Table A INNER JOIN TableB ON ................
WHERE...................

Posted 30-Jun-14 23:41pm

Shameel

Updated 1-Jul-14 22:35pm

v2

Comments

mitchiee1226 1-Jul-14 21:05pm

CASE a.column2 <= b.column3 [THEN]<--Change this TRUE [1 ELSE]<--How come there is an Error here? 0 END AS billPaid

mitchiee1226 1-Jul-14 21:16pm

Finally got your answer. Thanks! :D

CASE WHEN a.column2 >= b.column3 THEN 1 ELSE 0 END AS billPaid

[no name] 2-Jul-14 4:35am

Answer updated.