Thank you, Wesley and Emily. No, I did not think SSIS - I never used it. The update I am building will be used once a year so I am...

With help of David Dye, MSDN Moderator the following working solution was built:

-- 1. Create table with primary key and identity

CREATE TABLE [dbo].[DataPoint](

[DataPointID] [int] IDENTITY(1,1) NOT NULL,

[SubmittedTestID] [int] NOT NULL,

[DataPoint]...

I probably poorly described my question. The parameters are in Reporting Services. Each parameter is using its own dataset (also in SSRS). Each dataset is created by a stored procedure...

Thank you very much, both of you. Your solution resolved "Sintax error" problem. As I am trying to make sure entire stored procedure still performs as it should I am...