insert into ... newid() and select statement

[almoes]

Hi all,

I want to insert into a table all records result from a select statement with a previous field which creates a unique identifier (newid()). I tried, with no succes the following syntax:

insert into myTable(field1, field2,field3) newid() select field1, fields from myTable2

is this possible? thanxs.

cheers,
alej

 

[vongrunt]

Close shot...

insert into myTable(field1, field2,field3) select newid(), field1, field2 from myTable2

 

[almoes]

Cool! thanxs!

alej