Best method to identify nulls in columns in all columns
Posted on 2014-11-25
I have a table with about 30+ columns. Of all those columns I want to check every column to see if all the rows have nulls in them.
I want to display all the column names and if they were all nulls or not.
I started with a select statement with Case's but was not getting what I was hoping for so I figured there was a better way.
Any advice would be great!
Thanks in advance.
--Display something like this: (comments would not show ect)
AKAFirst 0 --this would be that all rows were null
AKAMiddle 8 --this would be 8 rows have data
AKASurname 15 --this wold be 15 rows have data
AltAssess 0 --this would be that all rows were null