Hi,
I have these tables and data:
CREATE TABLE [Table1](
[PartnerSiteID] [int] IDENTITY(1,1) NOT NULL PK,
[PartnerID] [int] NOT NULL,
[Code] [varchar](50) NOT NULL,
[Name] [varchar](150) NULL
)
CREATE TABLE [TableCategory](
[TableCategoryID] [int] IDENTITY(1,1) NOT NULL PK,
[CategoryName][varchar](50) NOT NULL
)
CREATE TABLE [TableCategoryLink](
TableCategoryLinkID [int] IDENTITY(1,1) NOT NULL,
[TableCategoryID] [int] NOT NULL,
[PartnerSiteID] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
TableCategoryLinkID ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE TableCategoryLink WITH CHECK ADD CONSTRAINT [FK_CategoryID] FOREIGN KEY(TableCategoryID)
REFERENCES [TableCategory] (TableCategoryID)
GO
ALTER TABLE TableCategoryLink WITH CHECK ADD CONSTRAINT [FK_PartnerSiteID] FOREIGN KEY([PartnerSiteID])
REFERENCES [Table1] ([PartnerSiteID])
GO
INSERT [Table1] ([PartnerSiteID], [PartnerID], [Code], [Name]) VALUES (1, 1, N'0001', N'Name1')
GO
INSERT [Table1] ([PartnerSiteID], [PartnerID], [Code], [Name]) VALUES (2, 1, N'0002', N'Name2')
GO
INSERT [Table1] ([PartnerSiteID], [PartnerID], [Code], [Name]) VALUES (3, 1, N'0003', N'Name3')
GO
INSERT [Table1] ([PartnerSiteID], [PartnerID], [Code], [Name]) VALUES (4, 1, N'0004', N'Name4')
GO
INSERT TableCategory (TableCategoryID, [CategoryName]) VALUES (2, N'Archery')
GO
INSERT TableCategory (TableCategoryID, [CategoryName]) VALUES (3, N'Boxing')
GO
INSERT TableCategory (TableCategoryID, [CategoryName]) VALUES (4, N'Cycling')
GO
I want to write a procedure to load TableCategoryLink table, which is intermediate table, I want to make a call once and load bulk records. please help.