ansaurus

Question

SQL Stored Procedure - Count Specific Not Null Columns in a Row

Answer 1

A:

select count(*) from table where data != null and structure !=null and loadid = a number

NimChimpsky 2010-09-13 10:16:47

I need to select the number of columns not null in the row, not the number of rows.

Byron Cobb 2010-09-13 10:28:30

not sure I understand entirely, do you want a count for each row or a total count of all null values; but cte's (common table expression) may be useful.

NimChimpsky 2010-09-13 10:52:55

I'll try explain best I can : Select 1 row - select data, if it's null count+=1, select structure, if it's null count+=1. I need to do something like that in sql server 2008 stored procedure.

Byron Cobb 2010-09-13 10:59:21

Answer 2

+1 A:

select case when Data is null then 1 else 0 end + 
case when Structure is null then 1 else 0 end as null_columns_amount 
from YourTable 
where LoadID = ?

Tommi 2010-09-13 10:59:29

Perfect, Thanks!

Byron Cobb 2010-09-13 11:25:08

ansaurus

tags:

views:

answers:

SQL Stored Procedure - Count Specific Not Null Columns in a Row

related questions