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 |
|
mart0369
Starting Member
11 Posts |
 Posted - 2008-10-03 : 11:40:34
|
| Is there a way to return only the columns in a record that are not null, without listing all the column names?I have a table with bits, and I want to return only the columns that are set. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 11:55:30
|
| Why should you want to change number of columns returned dynamically? What happens if one column has NULL in one row and non null value in other. you should retrieve all columns and then do formatting to show NULL values as some default value at your front end. |
 |
|
|
|
|
|
Only cloumns that are not NULL