sandeep kumar

sandeep kumar

  • 1.9k
  • 58
  • 5.1k

Do not display Columns which are not null

Aug 28 2018 2:29 PM
I have 10 columns in my table among those three columns are date fields. I am using SQL DATASOURCE in ASP.NET. 
I want to display all the records which are null and also display records any one column is also null. But not the records which are not null.
 
SELECT COLUMN1, COLUMN2, COLUMN3, COLUMN4,column5,column6, column7, column8, column9, column10 FROM TABLE
WHERE column8 is null or column9 is null or column10 is null
 
How can I Achieve this in SQL Datasource, with editible option. 
 
 

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (1)