Anything like Oracle's "Create Table As Select"?

• wjramsey

  Grasshopper

  Points: 15

  More actions

  January 2, 2002 at 1:38 am

  #158058

  Is there anything similar to Oracle's create table as select statement in SqlServer 2000?

  ex.

  create table dimension as

  select a.division

  b.department_name

  c.employee_name

  from division a,

  department b,

  employees c,

  where c.department_fkey = b.department_key

  and b.division_fkey = a.division_key

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  January 2, 2002 at 2:48 am

  #421557

  This will work ok, but to select into a permanent table, execute sp_dboption to turn on the select into/bulkcopy option before executing the SELECT statement. :

  SELECT a.division

  b.department_name

  c.employee_name into dimension

  from division a,

  department b,

  employees c,

  where c.department_fkey = b.department_key

  and b.division_fkey = a.division_key

  Paul Ibison

  Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com