>>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
>
>Hi Don,
>
>You should do:
>
>

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

Thanks Hugo!