INSERT INTO SdPosTerminals (PosTerminalID, VenueID, TerminalName, TerminalNo, RevGroup, IsActive) VALUES (1100, (SELECT V.VenueID FROM SdVenues V WHERE V.VenueID > 0), 'Terminal 2', 'Conf', 1000, 1);

 

INSERT INTO SdPosTerminals (PosTerminalID, VenueID, TerminalName, TerminalNo, RevGroup, IsActive) VALUES (1101, (SELECT V.VenueID FROM SdVenues V WHERE V.VenueID > 0), 'Terminal 1', 'Acc', 1000, 1);

 

INSERT INTO SdPosTerminals (PosTerminalID, VenueID, TerminalName, TerminalNo, RevGroup, IsActive) VALUES (1099, (SELECT V.VenueID FROM SdVenues V WHERE V.VenueID > 0), 'POSAdmin', 'POSAdmin', 1000, 1);