quote:

---

Originally posted by sparrow37

Hi all,

I have following stored proceudre which has two problems

1) inserts duplicate values instead of unique
2) and when i want to update, it inserts instead of updating.

SQL is :

ALTER PROCEDURE [dbo].[MapPartTypeManufacturer]
(
@CustomerId INT,
@PartType VARCHAR(20),
@ManufacturerId INT,
@ManufacturerName VARCHAR(200)
)

AS
BEGIN

IF EXISTS (SELECT * FROM tblAutoManufacturers WHERE iCustomerId = @CustomerId
and sPartType = @PartType
)
BEGIN
UPDATE
tblAutoManufacturers
SET
sPartType = @PartType,
iManufacturerId = @ManufacturerId,
sManufacturer = @ManufacturerName
WHERE
sPartType = @PartType and
iCustomerId = @CustomerId
END
ELSE
BEGIN
INSERT INTO
tblAutoManufacturers
(iCustomerId, sManufacturer, iManufacturerId,sPartType)
VALUES (@CustomerId, @ManufacturerName, @ManufacturerId, @PartType)
END

END

for example the problem i have let me give you one scenario for customer 1 for same parttype but for different manufacturer name,
it should add new record but when i want to edit this by changing the manufacturer name, it should update the existing record
but what it does is, it adds a new record.

Please help me on this urgently,

Regards,
Asif Hameed

---