Query to select not Null records in SQL Server

meetsree...

SOLVED CLOSED ACTIVE ANSWERED
User: meetsree83
Posted: on Sep 04, 2019 02:01 AM
Forum: SQL Server
Answer: 1
Views: 1708

Dear All,

I have the query mentioned below.

SELECT [BNK_OrgNum],[BNK_RecRef],[MsgTp_RecRef],[MsgTyp_MsgID],[MsgTyp_Desc],MsgTyp_FK_ServType,MsgTp_Active 
FROM [Bank_Master],[SysDef_MessageType],[Bank_MsgType]
WHERE [MsgTp_FK_MsgType]=[MsgTyp_RecRef] AND [MsgTp_FK_Bank]=[BNK_RecRef] 
--AND [MsgTp_Active]=0

For Some BNK_OrgNum the MsgTp_Active column=1 ,some MsgTp_Active=0. I need a query where the MsgTp_Active=0 where the BNK_OrgNum is not using any MsgTyp_MsgID

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 04, 2019 02:08 AM
Report

Check below query.

SELECT [BNK_OrgNum],[BNK_RecRef],[MsgTp_RecRef],[MsgTyp_MsgID],[MsgTyp_Desc],MsgTyp_FK_ServType,MsgTp_Active 
FROM [Bank_Master],[SysDef_MessageType],[Bank_MsgType]
WHERE [MsgTp_FK_MsgType]=[MsgTyp_RecRef] AND [MsgTp_FK_Bank]=[BNK_RecRef] 
AND ([MsgTp_Active]=0 AND BNK_OrgNum IS NULL)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Query to select not Null records in SQL Server

Company

Explore

Follow us

Contact Us