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)|