1
Answer

Display Data DocNo only once if repeated

Ramco Ramco

Ramco Ramco

2d
42
1
CREATE TABLE [dbo].[Test](
    [DocEntry] [int] NOT NULL,
    [Itemcode] [nvarchar](50) NULL,
    [Linetotal] [numeric](19, 6) NULL
) ON [PRIMARY]

GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2560209620', CAST(15400.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2560512620', CAST(7700.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2690001820', CAST(9800.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2560900320', CAST(5960.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2560901520', CAST(4040.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2580100220', CAST(3260.000000 AS Numeric(19, 6)))
GO

doc     itemcode    linetotal
34676    2560209620    15400.000000
34676    2560512620    7700.000000
34676    2690001820    9800.000000
34677    2560900320    5960.000000
34677    2560901520    4040.000000
34677    2580100220    3260.000000

I want output like below

doc     itemcode    linetotal
34676    2560209620    15400.000000
        2560512620    7700.000000
        2690001820    9800.000000
34677    2560900320    5960.000000
         2560901520    4040.000000
        2580100220    3260.000000

Answers (1)