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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Topaz70

    update table column based on another column value

    This is the table in need to update will it work by below syntax UPDATE sys_time SET time_con_sdate = (SELECT st1.time_con_sdate FROM sys_node sn1, sys_node sn2, sys_node sn3, sys_node sn4...
  2. Topaz70

    update table column based on another column value

    Hi Tharg st4.time_con_sdate is feild do we need to change update to table name instead of field name
  3. Topaz70

    update table column based on another column value

    Thanks Tharg for your note. I found out there are no primay keys for the tables so is there an alternate way to do it.
  4. Topaz70

    Suggestions on how to update one database to another

    You have two options one is using DTS packages or another using Replication process.Chek under BOL online how use these process.
  5. Topaz70

    update table column based on another column value

    I have statement need to update based on value st4.time_con_sdate using the value from st1.time_con_sdate and st4.time_con_edate with the value from st1.time_con_edate. SELECT st1.time_treeid AS "room time id", st4.time_treeid AS "questionable time id", st1.time_handle, cass_code AS "case...

Part and Inventory Search

Back
Top