How would I tie back a table such as the one below to the trigger?
USE GK50LIVE;
GO
SET NOCOUNT ON;
USE GK50LIVE
go
-- Create LIMITEDLOGINS Table
CREATE TABLE dbo.LimitedLogins
(
Id INT IDENTITY(100,1) PRIMARY KEY
,Login_Name VARCHAR (50) NOT NULL
,LOGIN_ID VARCHAR (50) NOT NULL
,NUM_ALLOWED TINYINT NOT NULL
,Date_Added Date NULL
);
--Add values to the LimitedLogins Table
USE GK50LIVE
go
INSERT INTO LimitedLogins
(Login_Name , LOGIN_ID, NUM_ALLOWED)
VALUES
('James Smith', 'jsmith','1')
,('Joe Kim', 'jkim','1')
,('Gary Harpogian', 'gharpogian','1');