Copying records using Select Into
I have a table [x] that has records with a Company Id field. When I add a new company (talbe [y]) I want to copy all the records in table x into table x with the new Company Id. This allows me to have different values for each company in table x.
Does this make sense?
I have seen the Select Into sql syntax, but this only creates a new table. I have used this to create a temp table where I can change all the Company Id's, but do I have to really Insert each line back into table [x]?
Any ideas much appreciated...