How could I (under T-SQL) combine make this INSERT statements simpler:

INSERT INTO ig VALUES ('050016994' , 1999, 14.0)
INSERT INTO ig VALUES ('050016995' , 1999, 14.0)
INSERT INTO ig VALUES ('050016996' , 1999, 14.0)


I dont want to simply have 3 VALUES clauses for one INSERT:

INSERT INTO ig VALUES ('050016994' , 1999, 14.0) VALUES ( ...) VALUES
( ...)

But I want to somehow use a SELECT to "stream" the variable value in:

INSERT INTO ig (column_name, 1999, 14.0) (SELECT column_name FROM
table WHERE column_name BETWEEN '050016994' AND '050016996')

On 16 Nov, 15:21, metaperl <metap... (AT) gmail (DOT) com> wrote:
insert into ....
select column_name, 1999, 14.0 from T where ...

/Lennart

SQL Server 2008 finally has the table constructor syntax:

INSERT INTO ig
VALUES ('050016994' , 1999, 14.0),
('050016995' , 1999, 14.0),
('050016996' , 1999, 14.0);


Of course not! Your syntax was illegal.

Unh? SQL is set-oriented; we insert a whole set and not a stream.