DECLARE @Today datetime
SET @Today = GETDATE()

INSERT TableA
(val1, val2, val3, entryDate)

OUTPUT
inserted.ID As TableAID,
C.comID As comID,
1 As RelationshipID,
'100.00' As xPercent,
1 As [status],
@Today As dateBegin 
INTO TableB (TableAID, comID, RelationshipID, xPercent, [status], dateBegin)

SELECT val1, val2, val3, @Today As entryDate
FROM TableC C

/*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 

Far away is close at hand in the images of elsewhere.

Anon.