AZZA-KHAMEES
asked on
create a new table from view
Hi Experts
i am trying to copy the content of the view to a new table
i am using this query
and i am getting this error
i even tried this
also not working i am getting this error
can you help me please
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
SELECT Description
INTO temp_courses
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER