Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by artmaat
-
Swap fields in a table
I need to switch the info in two fields basically reverse the info. I have several hundred records to deal with. This needs to be done only when a third field is <null> So its like this: 1) Switch COSTCODE and EQUIPMENT when EMPLOYEE is <NULL> 2) Then when EMPLOYEE is <NULL> change to '52001'...- artmaat
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Duplicating records with a few changes
Can't seem to get it to work , this is what I'm trying.. Insert into IM_ITEMFILE (col1, col2, col3, col4, col5) select col1, 'C52','52', col4, col5 from IM_ITEMFILE result Server: Msg 207, Level 16, State 1, Line 1 Invalid column name 'col1'. Server: Msg 207, Level 16, State 1, Line 1 Invalid...- artmaat
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Duplicating records with a few changes
I need to duplicate 600 records in a data base table and make some changes along the way . Need some help on this. Basically select a table and all of its fields, duplicate the data to make new records except that two of the fields that have the same info in all of them , will be changed to have...- artmaat
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
