If you want to insert data into both table in single query then you can use it like :
MERGE INTO Table1 AS t1
USING MyTable ON 1=0
WHEN NOT MATCHED BY TARGET THEN
-- INSERT into Table1:
INSERT (qutionid, qution, date) VALUES (t1.qutionid, t1.qution, t1.date)
--- .. and INSERT into Table2:
OUTPUT inserted.ID, MyTable.optionid, MyTable.qutionid, MyTable.optionno, MyTable.option, MyTable.date
INTO Table2 (ID, optionid, qutionid, optionno, option, date);
Hope this will is what you are looking for.
DNS Gold Member
"Failure is the path of least persistence"