Viewing 5 posts - 1 through 5 (of 5 total)
bit late now, my finger's are sore and i'm ready for home 🙂
July 25, 2003 at 8:53 am
#467095
Was hoping there was some form of shorthand way of doing it. There are 236 fields!
Never mind though, many thanks for your help!!!
July 25, 2003 at 8:29 am
#467082
quote: Something like this (Check it out in BOL): update <master_Table> set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 .... from <master_table>, <temporary_table> ...
quote:
update <master_Table>
set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 ....
from <master_table>, <temporary_table>
...
July 25, 2003 at 8:05 am
#467069
quote: insert <master_table> select <col1>, <col2> from <temporary_table> where not exists (select * from <master_table> where <temporary_table>.<Primary_Key> = <master_table>.<primary_key> ) ie insert a row where it does...
select <col1>, <col2>
from <temporary_table>
where not exists (select * from <master_table> where <temporary_table>.<Primary_Key> = <master_table>.<primary_key> )
ie insert a row where it does...
July 25, 2003 at 7:28 am
#467038
quote: only importing 'new' data? What about creating a DTS package? You can use the DTS Import/Export wizard and in one of the last steps...
What about creating a DTS package?
You can use the DTS Import/Export wizard and in one of the last steps...
July 25, 2003 at 6:17 am
#467017