updating sql view to sql table

• Trout

  SSC Eights!

  Points: 814

  More actions

  September 29, 2009 at 2:34 am

  #210207

  i have a linked view from another server, we have created tables with the exact same column and field types.

  I need to update the table with the data from the views.

  is there a bulk insert

  or do I drop the table and create from view.

  mytable

  pay_code 4varchar,null

  pay_type 5varchar,null

  myview

  pay_code 4varchar,null

  pay_type 5varchar,null

  data is static but view changes when the database is updated on the other server.

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  September 29, 2009 at 5:13 am

  #1059388

  you can use select into statement.

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]