SQL: Inserting data from table1 with static data into table 2

[RobGT]

Hi,
I'm trying to create an SP in SQL Server 2000 that will read in a load of
row values and insert them, along with two static values, into another
table.
I can't get my head to work right at the moment either, which isn't helping
:)

Here's what I have, which obviously doesn't work - any suggestions
appreciated.

CREATE PROCEDURE dbo.spIssues
@UserID int
AS
BEGIN
INSERT INTO t1 (ID, OtherID, MainValue)
VALUES (1272, 5, (SELECT MainValue
FROM t2
WHERE t2.ID = 1272)
)
END
GO

There must be an easy way to do this, I just can't think straight at the
moment!
Any help appreciated...
Cheers,
Rob

[Julian Roberts]

You need to clear you mind of clutter :)

INSERT INTO t1 (ID, OtherID, MainValue)
SELECT 1272,5, MainValue
FROM t2
WHERE t2.ID = 1272

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[RobGT]

Thanks Jules!

Rob