Using SProc to insert data

• dean gross

  SSCrazy

  Points: 2632

  More actions

  August 17, 2009 at 11:42 am

  #135569

  I have an existing sproc that returns 15 fields and I'd like to use this to insert data into a table that only has 10 fields. Is there any way to ignore the extra fields in an Insert statement or do i need to create a new sproc?

  TIA

  Dean

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  August 17, 2009 at 11:59 am

  #1040391

  Your stored proc returns a result set I assume, so I assume you're asking if you can do something like:

  INSERT INTO TABLE (COLUMNS)

  EXEC StoredProc

  To my knowledge, no, you can't do that. What you can do is create a temp table or table variable, insert it into that table, and then from there, you can insert the values you want into your table.

  EG:

  DECLARE @TempTable TABLE

  (

  AllColumnsFromStoredProc

  )

  INSERT INTO @TempTable (AllColumnsFromStoredProc)

  EXEC StoredProc

  INSERT INTO RealTable (ColumnsToInsert)

  SELECT ColumnsToInsert FROM @TempTable