Hi -

I am under the impression that an SQL INSERT statement can be used with a subquery to insert multiple rows at a time. My attempt

INSERT INTO [myData].[dbo].[TempRevenues2] (fisyear) values ((SELECT DISTINCT fisyear from RTA_REVENUES))

is producing an error. Do I have something wrong in the syntax or what am I missing?
Thanks