I've a case the of a stored procedure that is executed using a SqlCommand object using ExecuteNonQuery. I expect to insert one record but it inserts 22 exact records because I'm using and identity field as the key. I used debug to test that the code is only executed once and reviewed the stored procedure that passes every parameter to be inserted. I'm perplexed and could use some good recommendations as to why this might be happening.

ALTER PROCEDURE dbo.spProjectAdd

)
AS

INSERT INTO dbo.vtblProjID (ProjID, ProjName, TrbReq, CcbReq, PrincipalContact, LocalDir,
DeployTarget, ApplName)


FROM dbo.vtblProjID

Hi,

your INSERT syntax is not like what you intend I suppose. Use this:

INSERT INTO dbo.vtblProjID (ProjID, ProjName, TrbReq, CcbReq, PrincipalContact, LocalDir,
DeployTarget, ApplName)

--
SvenC

Your statement inserts a row for each record in vtblProjID table.

Rewrite your statement as follows:

INSERT INTO dbo.vtblProjID (ProjID, ProjName, TrbReq, CcbReq, PrincipalContact, LocalDir, DeployTarget, ApplName)

I don’t understand why you are using INSERT/SELECT as you don’t select any row from vtblProjID table.