Hi

Sample data from ##stagenulllogouts2

AttendanceID kioskTransactionId...

Table Data

CREATE TABLE [dbo].[PacomTransactionHistory] (

[TransactionID] [int] IDENTITY (1, 1) NOT NULL ,

[TransactionType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[TerminalID] [int] NOT NULL ,

[InductionNo] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CardSerialNumber]...