i am trying to copy the content of the view to a new table
i am using this query
CREATE TABLE temp_Courses
AS (SELECT distinct(Description) FROM [Training].[dbo].[masCourse]);
and i am getting this error
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.
i even tried this
FROM (SELECT distinct Description FROM [Training].[dbo].[masCourse])
also not working i am getting this error
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ')'.
can you help me please