ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Query to select not Null records in SQL Server<p>Check&nbsp;below query.</p> <pre class="brush: sql">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)</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/362478/Query-to-select-not-Null-records-in-SQL-Server/https://www.aspforums.net:443/Threads/362478/Query-to-select-not-Null-records-in-SQL-Server/Wed, 04 Sep 2019 02:08:52 GMT