----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sometimes, winning is not an issue but trying.
You can check my BLOG here
CREATE TABLE TestTable (id INT IDENTITY, string VARCHAR(100))GOCREATE TRIGGER TestTrigger ON TestTableINSTEAD OF INSERTAS IF OBJECT_ID('tempdb..#id') IS NOT NULL INSERT TestTable (string) OUTPUT inserted.id INTO #id SELECT CASE WHEN string = 'TestString' THEN string ELSE 'Stub' END FROM inserted ELSE INSERT TestTable (string) SELECT CASE WHEN string = 'TestString' THEN string ELSE 'Stub' END FROM insertedGOCREATE TABLE #id (id INT)SELECT * FROM TestTableINSERT TestTable (string)SELECT x.stringFROM ( SELECT 'TestString' AS string UNION ALL SELECT 'AnotherString' AS string ) xSELECT * FROM #idGO