Select only columns where there are values (dynamic select statement)

[Sindre Ek]

I would like to select only columns that have values.I have 101 columns and many of the columns dont have values when I do filter on 1 column. I know i can hardcode in the select statement, but I would like to keep it dynamic.

Example:

ID, Owner, Sale, Amount

1, null, 3, 10

2, null, 5, 99

 

Result,

ID, Sale, Amount

1, 3, 10

2, 5, 99

 

 

Would appreciate any possible solutions on this.