Save output table in sql server

• Teewhy

  SSC Veteran

  Points: 203

  More actions

  November 22, 2023 at 2:05 pm

  #4332475

  How can I save the output table from the join code below in sql server.

  select * from [Products]  join  [Sales] on [Sales].Item_name = [Products].Item_name

  NB: Usually, I would go join the table in SSIS and load into sql server but I want to a faster one.

• DesNorton

  SSC-Insane

  Points: 24348

  More actions

  November 22, 2023 at 2:45 pm

  #4332490

  You have to create a table to store it in

  CREATE TABLE foo (col1, col2, etc)

  Then insert the results into it

  INSERT INTO foo (col1, col2, etc)
  SELECT col1, col2, etc
  FROM [Products] AS p
  INNER join [Sales] AS s ON s.Item_name = p.Item_name

  ---

  How to post data/code on a forum to get the best help.