Updating NULL values

[titans4771]

I am trying to update a table I created that have NULL in one of the fields.


UPDATE clientidtoclientrollup
SET rollupid = clientid
WHERE clientid is null

Returns: (0 row(s) affected)

Thanks for any suggestions...

 

[JeffModen]

What do you get for the following?

 SELECT COUNT(*)
   FROM ClientIdToClientRollup
  WHERE ClientId IS NULL

--Jeff Moden
-------------------------------------------------------------------------------
"RBAR" is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row

 

[markros]

Did you want to put NULL into the other field too for all records where ClientID IS NULL? May be you wanted to do this where ClientID IS NOT NULL ?

 

[JeffModen]

Ah... I hadn't thought about that. I just took the code at face value. Perhaps what is sought could be the following?

 UPDATE ClientIdToClientRollup
    SET RollupId = ClientId
  WHERE RollupId IS NULL
    AND ClientID IS NOT NULL

--Jeff Moden
-------------------------------------------------------------------------------
"RBAR" is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row

 

[titans4771]

Thanks!!