yuvipoy (12/27/2012)
Hi,How to find column is having value or not
Id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 1 NULL 2 NULL 3 NULL
1 9 NULL 8 NULL 4 NULL
Expected ans
Id, Col_1,Col_3,Col_5
which is having some value other than NULL
Thanks!
i dont know whats your actual requirement but definitely not what have you explained in your above query.
anyways, you can restrict/make conditional the records or data display but NOT the columns . select part will be always confirmed and unconditional.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)