It would be a varchar field of 15 (??) characters, starting with 0 and
then write something that increments that every new entry. I'm not a SQL
person so I don't know how to do that.
Drew
Wed, 20 Aug 2008, Moore, Christopher Allen 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
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Drew Shuller
Sent: Wednesday, August 20, 2008 3:09 PM
To: [email protected]
Subject: Re: Another view form question...
You've got to have that key field and it must be in the format that is
in the documentation. Create a new column if you don't have a suitable
one already.
Drew
On Wed, 20 Aug 2008, Moore, Christopher Allen wrote:
I have a problem creating a view form- thanks to Joe's advice I am now able to
see all the columns. My problem now is designating a key field. The only
column which is guaranteed to be unique is a GUID passed from the external data
source, but it's too long- 25 characters.
Has anyone else run into this problem, and how did you get around it? I can't
use ROW_ID because this table will be overwritten monthly. I know just enough
SQL to be dangerous...is there some sort of way to add a column and ensure it's
unique via SQL?
ITSM 7.0.1 p6
SQL 2005 SP2
Win 2003 svr
I appreciate any advice!
Chris
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
