SQLTeam.com | Weblogs | Forums

Not show empty records and show records in one row SQL

I have below table I generated with script
CoulumnID--Coulmn1--Column2--Column3 => header of table
1111111111--C1 --EMPTY --EMPTY
222222222--C1 --EMPTY --EMPTY
--EMPTY --C2 --EMPTY
333333333--C1 --EMPTY --EMPTY
--EMPTY --EMPTY --C3

SO, IWANT TO HAVE BELOW TABLE AS OUTPUT
CoulumnID--Coulmn1--Column2--Column3 => header of table
1111111111--C1 --EMPTY --EMPTY
222222222--C1 --C2 --EMPTY
333333333--C1 --EMPTY --C3

I CAN SEND YOU EMAIL THE PICTURE OF MY QUESTION

Please provide sample data as DDL and DML as follows. This is a sample you will need to provide your own for the question you are asking. Help us help you

--the following is DDL Data Definition Language
create table #jeevad(Documenttype varchar(50),
 Filepath varchar(50),Remarks varchar(50), Filename varchar(50),
DocumentNo int, Hijri  nvarchar(50),Gregorian nvarchar(50), issuedate date)

--the following is DML Data Manipulation Language
insert into #jeevad
select 'CR Certificate SAB General Contracting.', 
'c:/filename test', NULL, 123, NULL, NULL, NULL union

--etc etc etc