Home Forums SQL Server 2008 T-SQL (SS2K8) how to select only non null columns out of 100 plus columns table RE: how to select only non null columns out of 100 plus columns table
pietlinden
SSC Guru
Points: 63428
More actions
February 19, 2017 at 6:35 pm
#1929293
Do you mean you want to use some code to identify the columns that only contain nulls so that you can skip them? If you know which columns are always NULL, then just omit those from your query.