Database

CREATE TRIGGER InsteadUpdateTrigger on tblTable
INSTEAD OF UPDATE
AS
BEGIN
   UPDATE tblTable
        SET a=i.a,b=i.b,c=i.a+i.b
	FROM INSERTED i
        WHERE tblTable.IDField = i.IDField
END


CREATE TRIGGER InsteadInsertTrigger on tblTable
INSTEAD OF INSERT
AS
BEGIN
   INSERT INTO tblTable
       SELECT a,b,a+b
       FROM INSERTED
END

CREATE TABLE [tblTable] (
	[IDField] [int] IDENTITY (1, 1) NOT NULL ,
	[a] [int] NULL ,
	[b] [int] NULL ,
	<code>[c] AS ([a] + [b]) </code>,
	CONSTRAINT [PK_tblIDField] PRIMARY KEY  CLUSTERED 
	(
		[IDField]
	)  ON [PRIMARY] 
) ON [PRIMARY]

DECLARE @iColumns INT, @sql VARCHAR(2500),@cInstruction VARCHAR(50), @nInstruction int 

SET @sql = ''

DECLARE curInstructions CURSOR FOR SELECT DISTINCT InstructionDesc,InstructionID FROM TB_InstructionMaster
OPEN curInstructions
FETCH NEXT FROM curInstructions INTO @cInstruction,@nInstruction
WHILE @@FETCH_STATUS = 0
BEGIN
	SET @sql = @sql + ', (SELECT ''' + @cInstruction + ''' as fld 
                              FROM TB_ProductInstruction P2 
                              WHERE P2.ProductID = ProdInst.ProductID and InstructionID = ''' + 
                                    cast(@nInstruction as varchar) + ''') as [' + @cInstruction + ']'
	FETCH NEXT FROM curInstructions INTO @cInstruction,@nInstruction
END

close  curInstructions
DEALLOCATE curInstructions

SET @sql =  'SELECT distinct ProdMast.ProductID ' + @sql + ' 
FROM TB_ProductInstruction ProdInst 
right join tb_productmaster ProdMast on ProdInst.ProductID = ProdMast.ProductID'
exec(@sql)

select * from train 
LEFT OUTER JOIN trainarrivals ta1 ON train.PreviousArrival = ta1.UniqueID
LEFT OUTER JOIN trainarrivals ta2 ON train.NextArrival = ta2.UniqueID
ORDER BY train.UniqueID