/*TABLE A*/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TableA](

[ID] [int] IDENTITY(1,1) NOT NULL,

[val1] [varchar](50) NOT NULL,

[val2] [varchar](50) NOT NULL,

[val3] [varchar](50) NOT NULL,

[entryDate] [datetime] NOT NULL,

CONSTRAINT [PK_TableA] PRIMARY KEY CLUSTERED

(

[ID] 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

SET ANSI_PADDING OFF

/*TABLE B*/

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TableB](

[ID] [int] IDENTITY(1,1) NOT NULL,

[TableAID] [int] NOT NULL,

[comID] [int] NOT NULL,

[RelationshipID] [int] NOT NULL,

[xPercent] [varchar](6) NOT NULL,

[status] [int] NOT NULL,

[dateBegin] [datetime] NOT NULL,

CONSTRAINT [PK_TableA] PRIMARY KEY CLUSTERED

(

[ID] 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

SET ANSI_PADDING OFF

/*TABLE C*/

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TableC](

[ID] [int] IDENTITY(1,1) NOT NULL,

[val1] [varchar](50) NOT NULL,

[val2] [varchar](50) NOT NULL,

[val3] [varchar](50) NOT NULL,

[entryDate] [datetime] NOT NULL,

[comID] [int] NOT NULL,

CONSTRAINT [PK_TableA] PRIMARY KEY CLUSTERED

(

[ID] 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

SET ANSI_PADDING OFF

INSERT INTO TableC

(val1, val2, val3, entrydate, comID)

SELECT 'val11', 'val21', 'val31', GETDATE(), 100 UNION ALL

SELECT 'val12', 'val22', 'val32', GETDATE(), 200 UNION ALL

SELECT 'val13', 'val23', 'val33', GETDATE(), 300 UNION ALL

SELECT 'val14', 'val24', 'val34', GETDATE(), 400 UNION ALL

SELECT 'val15', 'val25', 'val35', GETDATE(), 500

Here you go.

TIA,

KK