ishimon
Last Activity: Mar 25 '08, 02:45 PM
Joined: Feb 14 '08
Location:
-
Thanks for clarifying. I was hoping to avoid naming fields but looks like there is no other way.... -
I am sorry - was in a rush earlier. Here is better explanation of the problem:
Table has: col1, col2, col3 - for example could be State, County, City plus other columns.
I need to insert duplicates of some group of records but to change column to a different value.
I know this will insert duplicates for col1 = somevalue
INSERT INTO Table VALUES ( SELECT * FROM Table WHERE col1 = somevalue)
...Leave a comment:
-
Duplicate records and set field to constant
I have a table on SQL 2000.
I need to duplicate a group of records into the same table but duplicates need to have one field set to constant.
Is it possible to modify Column value in the subselect?
Thanks
No activity results to display
Leave a comment: