I Want Null To Display In Every Column If Record Is Not Present In This Table How Do I Do It

Question

1.00/5 (1 vote)

See more:

SQL

SELECT TWCI_Job_Code,TWCI_Warehouse_code,SUM((TWCI_Quantity)) from SQLSCM.SCM_T_Warehouse_Cumulative_Issues
                                           where TWCI_Job_Code='mbbh7533' and TWCI_Warehouse_code=2668 and TWCI_Material_Code='109931300' and
                                           TWCI_Stock_Type_Code=4 and TWCI_Stock_Type_Detail_Code=11 and TWCI_Company_code=1 and
                                            TWCI_Start_Date>='2015-04-01' and TWCI_End_Date<='2015-04-28'
                                            GROUP BY TWCI_Job_Code,TWCI_Warehouse_code

Posted 13-May-15 18:49pm

manoswc

Add a Solution

Comments

Mehdi Gholam 14-May-15 0:58am

If a column is null then you will get null, what is your specific problem?

manoswc 14-May-15 4:37am

there is no column for the particular date specified in this scenario I want null inspite of getting nothing

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)

barneyman · Answer 1 · 2015-05-13T19:33:00

Solution 1

you'll have to do an EXISTS()[^] check, and of you get nothing, specifically return nulls
select NULL as TWCI_Job_Code, NULL as TWCI_Warehouse_code

Posted 13-May-15 19:33pm

barneyman

Comments

manoswc 14-May-15 4:38am

I am inserting it in another table this wil work out? using insert into tablename select from