InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 01:33:17 GMT20http://www.sqlservercentral.com/Forums/Topic1416209-392-1.aspx[quote][b]Mac1986 (2/5/2013)[/b][hr]Hi All, I have a table in which one of the column is UniqueIdentifier. I have NULLS from records 1 through 91 and then after I have records populated in the table. I need to fill up the NULLS with UniqueIdentifier. Can you please help me.My only concern is if I update the table now, after few months when new UniqueIdentifier gets generated as part of our ETL, which is once a day, should not cause duplicates.Please help.[/quote][code="sql"]update dbo.MyTable set UniqueIdentifierCol = newid()where UniqueIdentifierCol is null;[/code]Chances of a dup are quite low, but not impossible.Tue, 05 Feb 2013 21:00:11 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1416209-392-1.aspxHi All, I have a table in which one of the column is UniqueIdentifier. I have NULLS from records 1 through 91 and then after I have records populated in the table. I need to fill up the NULLS with UniqueIdentifier. Can you please help me.My only concern is if I update the table now, after few months when new UniqueIdentifier gets generated as part of our ETL, which is once a day, should not cause duplicates.Please help.Tue, 05 Feb 2013 20:37:40 GMTMac1986