Hello friends I need help for the below query. My table structure is
as such
-------------------------------------------------------------------------------
CatCode | GradeCode | ItemCode | HeatCode | SizeLot
-------------------------------------------------------------------------------
01 | A105 | A | H1 | S1
01 | A105 | A | H2 | S1
01 | 0304 | A | H3 | S2
01 | 0LF2 | A | H4 | S4
02 | A105 | B | H1 | S1
02 | A105 | B | H2 | S1
02 | A266 | C | H3 | S2
02 | F304 | C | H4 | S4


CREATE TABLE [dbo].[Tmp_ItemBatchDetails](
[CatCode] [varchar](2),
[GradeCode] [varchar](10),
[ItemCode] [varchar](20),
[HeatCode] [varchar](12),
[SizeLot] [varchar](20)
)


insert into Tmp_ItemBatchDetails values('01','A105','A','H1','S1')
insert into Tmp_ItemBatchDetails values('01','A105','A','H2','S1')
insert into Tmp_ItemBatchDetails values('01','0304','A','H3','S2')
insert into Tmp_ItemBatchDetails values('01','0LF2','A','H4','S4')
insert into Tmp_ItemBatchDetails values('02','A105','B','H1','S1')
insert into Tmp_ItemBatchDetails values('02','A105','B','H2','S1')
insert into Tmp_ItemBatchDetails values('02','A266','C','H3','S2')
insert into Tmp_ItemBatchDetails values('02','F304','C','H4','S4')


My result should be as such
-------------------------------------------------------------------------------
CatCode | GradeCode | ItemCode | HeatCode | SizeLot
-------------------------------------------------------------------------------
01 | A105 | A | H1 | S1
01 | A105 | A | H2 | S1
01 | 0304 | A | H3 | S2
01 | 0LF2 | A | H4 | S4
01 | A266 | Null | Null |
Null
01 | F304 | Null | Null |
Null
02 | A105 | B | H1 | S1
02 | A105 | B | H2 | S1
02 | A266 | C | H3 | S2
02 | F304 | C | H4 | S4
02 | 0304 | Null | Null |
Null
02 | 0LF2 | Null | Null |
Null

Please help for the same.