Hi All,

has anybody tried Inserting records to a table using combination of parameter and SELECT? Below is my stored proc:

create procedure mySP
(
  @ds_id int,
  @product varchar(30),
  @system varchar(6)
)
as


begin tran

    insert into map
    (
        ds_id, --VALUE WILL COME FROM THE PARAMETER
        counterparty_id,
        counterparty_name,
        swift_code,
        related,
        rba,
        country_code,
        cp_code,
        comment,
        who_created,
        when_created,
        who_modified,
        when_modified,
        product -- VALUE FROM THE PARAMETER
    )

        VALUES (@ds_id,
       (SELECT
        counterparty_id,
        counterparty_name,
        swift_code,
        related,
        rba,
        country_code,
        cp_code,
        comment,
        who_created,
        when_created,
        who_modified,
        when_modified FROM map_r),
                @product)

commit tran



Here, I would like all the fields of map be replaced with the records from map_r, except the column of ds_id and product, which will be filled by the supplied parameter @ds_id and @product. However Im receiving errors . Is there a way to INSERT records to a table using combination of SELECT and parameterized values?

Thank you so much!

Get rid of the VALUES part and add the parameters to the SELECT:

--

Joe (Microsoft MVP - XML)