What about this test data?DECLARE @Ledger TABLE ( PATID INT, CODE CHAR(5), TRANDATE DATE );INSERT @Ledger ( PATID, CODE, TRANDATE )VALUES (1, 'Z1110', '19700715'), (1, 'D3330', '19700715'), (1, 'Z0330', '19700715'), (2, 'Z1298', '19700720'), (2, 'Z0987', '19700720'), (2, 'Z0330', '19700720'), (2, 'D1092', '19700720'), (3, 'Z0330', '19800820'), (3, 'Z0330', '19820211'), (3, 'Z1110', '19820211');
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA