SQL2005 has a newid() function that you can set a column to. It creates a 16-byte unique identifier...however, that may still be too long for Remedy...but it is worth a shot.
http://msdn.microsoft.com/en-us/library/ms190348(SQL.90).aspx Note that this may affect the way data is imported into the table from the external source. If your insert statements don't list the column names then changing or adding a column to the table may cause insert issues. If, on the other hand, your insert statements do list field names you should be okay. Here's a clearer explanation. Say your table (MyTable) has 5 columns named A, B, C, D and E. An insert can be implicit like so: INSERT MyTable VALUES (ValueA, ValueB, ValueC, ValueD, ValueE) SQL knows what to do because you have one value for each column. However if you were then to add a GUID column, defined as newid() you'd get an error trying to perform the insert because there would be more columns than data. If, however, your insert statement is explicit like so: INSERT MyTable (A, B, C, D, E) VALUES (ValueA, ValueB, ValueC, ValueD, ValueE) You should be okay because SQL would know which value goes with which column. The newid() function, however, may require a value be sent to it (see Example B on the URL above) which may require changing your data import method anyway. Sorry if this is overly technical...I was a DBA in a previous life and its hard to shake old habits. --- J.T. Shyman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, August 21, 2008 9:29 AM To: [email protected] Subject: Re: Another view form question... Look into using a sequence via a trigger to populate the column. Axton Grams On Wed, Aug 20, 2008 at 4:13 PM, Moore, Christopher Allen <[EMAIL PROTECTED]> wrote: > Drew- > I figured I'd have to create a new column, but how can I populate it? Is there a way in SQL to generate a GUID for each entry? > > Forgive my ignorance here; I don't know a lot on the SQL side. > > Thanks, > Chris > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
