Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markfrank22
Starting Member
1 Post |
 Posted - 2001-03-23 : 02:08:55
|
| Hi,I have managed to create an update DTS Lookup query which converts state codes to state names. However I am unable to update the destination table state codes. My Task only appends new records. Can anyone add the SQL code to make the following an update query:/*UPDATE Publishers2SET State = */ - I tried adding this to no avail. The piece below works. SELECT StateNameFROM tblStateLookupWHERE (StateAbbr = ?)Thanks for the help, just a novice starting out. |
|
|
|
|
|
DTS Lookup Update Query