• 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;-)