CREATE TABLE [dbo].[tblLabHeader](     [TransNo] [bigint] NOT NULL,     [PtName] [nvarchar](255) NULL,       [pId] [int] NULL);  insert into tblLabHeader values(1801183024655645551,'U VVV',308830898); insert into tblLabHeader values(1801188728667642868,'U VVV',308830898);   CREATE TABLE [dbo].[tblLabDetail](       [Results] [nvarchar](max) NOT NULL DEFAULT ('') ,     [N4] [bigint] NOT NULL DEFAULT ((0)),     [TestDesc][nvarchar](255) not null default(''),     [t6] [nvarchar](255) NOT NULL DEFAULT (''));  insert into tblLabDetail values('nnnn',1801183024655645551,'Complete Picture (CP-26 Parameter)' ,'2018011813:31:22'); insert into tblLabDetail values('vvvv',1801188728667642868,'Complete Picture (CP-26 Parameter)', '2018011810:28:53');   select SUBString(D.t6,1,8) as dater,CASE WHEN convert(int,SUBSTRING(D.t6,9,2))>=12  then Results+'(even)' else Results+'(mor)' end as Results ,D.TestDesc from tblLabHeader H inner join tblLabDetail D on H.TransNo=D.n4 where H.pId=308830898 and D.Results!=''     dater     |   Results   |    TestDesc ----------| ------------|-----------------------------------  20180118 | nnnn(even)  |Complete Picture (CP-26 Parameter)  20180118 | vvvv(mor)   |Complete Picture (CP-26 Parameter) 

I wanna belowing result– Please help me– Thanks

TestDesc | Day1 | Day2 ————————————–|————————-|—————– – | 18-01-2018 | – ————————————–|————————-|—————– Complete Picture (CP-26 Parameter) | nnnn(even)| vvvv(mor)|