Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rohit.manj
Starting Member
11 Posts |
Posted - 2010-07-19 : 01:47:45
|
Hi to all i hav 72 columns 30 of them are d1 ,d1 upto d31.some of them are filled and i want to count only filled columns .Please help meCRhudmude |
|
Trevinator
Starting Member
8 Posts |
Posted - 2012-10-16 : 19:58:06
|
try this select COUNT(*) from *where COUNT(*) IS NOT NULL; |
|
|
|
|
|