>>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?
>INSERT INTO [myData].[dbo].[TempRevenues2] (fisyear) SELECT DISTINCT fisyear from RTA_REVENUES >Thanks Hugo!