Hi

Did you try:

UPDATE mytable SET mycol = 'new vlaue' WHERE 'col' = 'value'

IF @@ROWCOUNT = 0

RAISERROR('No rows updated',16,1)

Regards

Mike

Jonathan AC Roberts (4/2/2012)

michal.lisinski (4/2/2012)

SELECT DISTINCT CustomerID

FROM [#Purchase]

WHERE (ProductCode IN ('A','B')) AND (CustomerID NOT IN

...

Jonathan AC Roberts (4/2/2012)

michal.lisinski (4/2/2012)

SELECT DISTINCT CustomerID

FROM [#Purchase]

WHERE (ProductCode IN ('A','B')) AND (CustomerID NOT IN

...

Hmm, r u sure? Customer no 6 took product A and no B, customer 7 took product B and no A, both didn't take C, but query doesn't return...

Imho

SELECT DISTINCT CustomerID

FROM [#Purchase]

WHERE (ProductCode IN ('A','B')) AND (CustomerID NOT IN

...