Re: help on creating missing ids

2007-09-22 Thread Shawn Green
Dimitar Vasilev wrote: Hi Shawn, Thanks for your response. I'm trying to assign uniquely a user id per share holder within the whole list, not within each company. Suppose we have a person John Smith that holds shares both in MonkeyBusiness and NoSuchThing. I'd like to give him an id that is the

Re: help on creating missing ids

2007-09-22 Thread Dimitar Vasilev
2007/9/22, Shawn Green <[EMAIL PROTECTED]>: > > Hello Dimitar, > > Dimitar Vasilev wrote: > > Hi all, > > I have a table shares that consists of > > company id, shareholder id, shareholder name. > > Company id and shareholder id are decimal digits; shareholder name is > text. > > Due to some missin

Re: help on creating missing ids

2007-09-22 Thread Shawn Green
Hello Dimitar, Dimitar Vasilev wrote: Hi all, I have a table shares that consists of company id, shareholder id, shareholder name. Company id and shareholder id are decimal digits; shareholder name is text. Due to some missings of my initial data, I'd like to create a unique id for the sharehold

help on creating missing ids

2007-09-19 Thread Dimitar Vasilev
Hi all, I have a table shares that consists of company id, shareholder id, shareholder name. Company id and shareholder id are decimal digits; shareholder name is text. Due to some missings of my initial data, I'd like to create a unique id for the shareholder ids which are blank/null in the import