RE: [KCFusion] Assigning unique ID's

[Greenhagen, Robin]

What about running a query like this in SQL Ent Mgr.

UPDATE table_name SET new_guid_fld=NEWID()

Now you will have a new Unique GUID on each record, and you can fix your 
IDENTITY/INDEX issue.

Thanks,
Robin Greenhagen
President
GSI (GreenSoft Solutions, Inc.)
http://www.gsi-kc.com/


> -----Original Message-----
> From: Ramphal, Ron [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 24, 2002 9:34 AM
> To: [EMAIL PROTECTED]
> Subject: [KCFusion] Assigning unique ID's
> 
> 
> Hello,
>  
> Might be real simple but it eludes me at this moment...
> I have a table in which the app somehow managed to assign 
> duplicate id's to different records, to fix I decided to add 
> an extra  field and propagate with a guid using CF's 
> CreateUUID function, can anyone explain how to do the whole 
> table in one pass, therefore creating a unique id for each record?
>  
> TIA,
>  
> Ron.
> N[  w鲲+Ȳo!♙w
> p븸
> +    Vry
> NJq捲zˢ{i۬i)>궶[疖+z~zぁ:&+rzG麺ȞNrzf~Xᶶ鹻&Dz*
> 
N�[����      b�֧w��+^��h�םo!�wR��^��'p���
܆+޲m����     
��V�r�y�&����dq�����.z�b�{�i���(�ih�)�>���隊[h�+-��-z�~�"�z+�:���&ޙ�����+-���r��zG�Ȩ���N�'���r��zf���~X���칻�&ޑ��*'��