BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	Declare @LN varchar(20) 
	SELECT @LN = i.LN FROM inserted AS i
	Declare @TestCode varchar(6) 
	SELECT @TestCode = i.Test_Code FROM inserted AS i
	Declare @ANA varchar(6) 
	SELECT @ANA = i.Ana_Name FROM inserted AS i

	if @ANA <> ''
	BEGIN
		UPDATE [dbo].[tbl_lab_information_Result_Items]
		   SET [IRESI_ANA_NAME] = @ANA
		 WHERE [IRESI_LN] = @LN and [IRESI_CODE] = @TestCode
	END
END
--------------------------------------------------------
CREATE TABLE [dbo].[Untitled] (
  [LN] nvarchar(50) COLLATE Thai_CI_AS  NOT NULL,
  [Barcode] nvarchar(25) COLLATE Thai_CI_AS  NOT NULL,
  [Specimen_Type_Code] nvarchar(2) COLLATE Thai_CI_AS  NULL,
  [Date_Receive] datetime DEFAULT getdate() NOT NULL,
  [Test_Code] nvarchar(10) COLLATE Thai_CI_AS  NOT NULL,
  [Test_Result] nvarchar(50) COLLATE Thai_CI_AS  NULL,
  [Ana_Name] varchar(50) COLLATE Thai_CI_AS  NOT NULL,
  [Ana_Flag] nvarchar(2) COLLATE Thai_CI_AS  NULL,
  [Result_Flag] nvarchar(5) COLLATE Thai_CI_AS  NULL,
  PRIMARY KEY CLUSTERED ([LN], [Barcode], [Date_Receive], [Test_Code], [Ana_Name])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)  
ON [PRIMARY]
GO

ALTER TABLE [dbo].[Untitled] SET (LOCK_ESCALATION = TABLE)
GO

CREATE NONCLUSTERED INDEX [Dta_tbl_lab_Analyzer_Result_copy1]
ON [dbo].[Untitled] (
  [Specimen_Type_Code] ASC,
  [Test_Result] ASC,
  [Ana_Flag] ASC,
  [Result_Flag] ASC
)
GO

CREATE TRIGGER [dbo].[UpdateAnalyzerName_copy1]
ON [dbo].[Untitled]
WITH EXECUTE AS CALLER
FOR INSERT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	Declare @LN varchar(20) 
	SELECT @LN = i.LN FROM inserted AS i
	Declare @TestCode varchar(6) 
	SELECT @TestCode = i.Test_Code FROM inserted AS i
	Declare @ANA varchar(6) 
	SELECT @ANA = i.Ana_Name FROM inserted AS i

	if @ANA <> ''
	BEGIN
		UPDATE [dbo].[tbl_lab_information_Result_Items]
		   SET [IRESI_ANA_NAME] = @ANA
		 WHERE [IRESI_LN] = @LN and [IRESI_CODE] = @TestCode
	END
END
GO

EXEC sp_addextendedproperty
'MS_Description', N'First=FI, Rerun=RR, Unmatch=UN',
'SCHEMA', N'dbo',
'TABLE', N'Untitled',
'COLUMN', N'Ana_Flag'
-----------------------------------------------------------