multiple insert statement
Hey Gang,
Got a problem trying to use an insert .. select statement to populate one table with anothers auto_generated key.
I don't know if i have the tables in sql server done properly as the tables are as follows:
[b]tbl_disclaimers[/b]
recnumberid int(4) not null -> identity yes, foreign key
callnumber varchar(255) not null,
backup bit(1) null,
antivirus bit(1) null,
delivery bit(1) null
)
[b]tbl_params[/b]
recnumberid int(4) not null primary key -> identity yes
amount money(8) null
my basic sql command is
INSERT INTO tbl_params
SELECT recnumberid
FROM tbl_disclaimers where recnumberid = '2'