Remove a column from out put, if the sum of that column is zero or null

declare @zerosumcolumn int
declare @nullcolumn int
set @zerosumcolumn = 0
set @nullcolumn = 0
if (
  (select sum(zerosumcolumn) from  table1) = 0
)
begin
  set @zerosumcolumn = 1
end
if (
  (select sum(isnull(nullcolumn, 0)) from  table1) = 0
)
begin
  set @nullcolumn = 1
end
if (@zerosumcolumn = 1 and @nullcolumn = 1)
begin
  select nonzerosumcolumn from table1
end
else if (@zerosumcolumn = 1)
begin
  select nonzerosumcolumn, nullcolumn from table1
end
else if (@nullcolumn = 1)
begin
  select nonzerosumcolumn, zerosumcolumn from table1
end
else
begin
  select * from table1
end