SQL query, not show report if previous value is same

[yosiasz]

here it is repeated again.

declare @sampledata table(MTR_NRO int,  TYA_ALKUKLO string,  --etc

insert into @sampledata
values(49186, '1.6.2022 7:29:00', --etc

like the following post as an example

SQL Query

Hello, I have a table below CREATE TABLE [dbo].[Trn_Invoice]( [Inv_No] [numeric](18, 0) NULL, [Inv_PhNo] [nvarchar](50) NULL, [Inv_OpRate] [numeric](18, 0) NULL, [Inv_STBRate] [numeric](18, 0) NULL, [Inv_Type] [nvarchar](50) NULL, [Inv_Days] [numeric](18, 0) NULL ) ON [PRIMARY] GO below is the data. INSERT INTO [Trn_Invoice] ( [Inv_No] ,[Inv_PhNo] ,[Inv_OpRate] ,[Inv_STBRate] ,[Inv_Type] ,[Inv_Days] ) VALUES (1, 'A1', 100, 50, 'OP', 2), (1, 'A1', 100…