SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Links](
	[Source] [int] NOT NULL,
	[Destination] [int] NOT NULL,
	[Date] [datetime] NULL DEFAULT (getdate()),
	[TypeID] [smallint] NOT NULL,
 CONSTRAINT [PK_Links] PRIMARY KEY CLUSTERED 
(
	[Source] ASC,
	[TypeID] ASC,
	[Destination] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE NONCLUSTERED INDEX [IX_Links_Destination] ON [dbo].[Links]
(
	[Destination] ASC,
	[TypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

INSERT INTO [dbo].[Links]([Source], [Destination], [Date], [TypeID])
SELECT o.[object_id], o2.[object_id], GETDATE(), 1 FROM sys.[objects] o
CROSS JOIN sys.[objects] o2 

IF OBJECT_ID('tempdb..#Inserted') IS NOT NULL DROP TABLE #Inserted
CREATE TABLE #Inserted 
(
  [ID] Int NOT NULL PRIMARY KEY CLUSTERED
) 

INSERT INTO #Inserted([ID])
SELECT TOP (10) o.[object_id] FROM sys.[objects] o 


SELECT DISTINCT
  [ID] = CASE WHEN I.[ID] = TL.[Source] THEN TL.[Destination] ELSE TL.[Source] END
FROM [dbo].[Links] TL
INNER JOIN #Inserted I ON I.[ID] = TL.[Source]
  OR I.[ID] = TL.[Destination]


SELECT DISTINCT
  TL.[Destination]
FROM [dbo].[Links] TL
INNER JOIN #Inserted I ON I.[ID] = TL.[Source]
UNION
SELECT DISTINCT
  TL.[Source]
FROM [dbo].[Links] TL
INNER JOIN #Inserted I ON I.[ID] = TL.[Destination]