i need to copy an entire row of data and insert it into a new insert command....
i was wondering since this
insert into userdetails select (UserName,FirstName,LastName) from userdetails where CurrentStatus=0;
is not possible (according to the manual) and i tried severay possible variations. now this is only a small example to show what i mean the record itself has 36 cols... at first i tought of doing a select (each field name... 36 alltogether) from userdetails where CurrentStatus=0 and then to do an insert according to the values i got from the select... but to do it for 36 different cols... is there any way to copy entir row into a new record?
thnx in advance.