Intsert into table that has unique id?

[gtjr92]

I am trying to instert data from one table into another. The source table does not have a uniqueIDentifier but the destination table does. How can I get the uniquid field to autopopulate when I do this insert?

insert into Members(address,phone,firstname,lastname,Email,City,State,zip,no_Permission,Others) Select address,phone,firstname,lastname,Email,City,State,zip,no_Permission,Others from DIR;

I keep getting Cannot insert the value NULL into column 'memberid', ; column does not allow nulls. INSERT fails.
The statement has been terminated.

 

[mrdenny]

Since you are getting this error you are not using an identity field. What method is the system using to generate the unique numbers?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[AccordingToDale]

Use this

insert into Members([i]memberid[/i], address,phone,firstname,
lastname, Email,City,State,zip,no_Permission,Others) 

Select [i](newid())[/i], address,phone,firstname,
lastname, Email,City,State,zip,no_Permission,Others 
from DIR;

dale

 

[mrdenny]

That will work fine, if you are using a uniqueidentifier. Are you using an uniqueidentifier or a number?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[gtjr92]

I will try what was suggested and let you know when i get a chance tommorow

 

[gtjr92]

worked like a charm thanks!