[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

update table data in 2 columns that's binary datatype based on comparison data from 2nd table that in char datatype

i have a two tables i'm using matching critiera from jursidictionid, licensetype, licensenumber, between the two table

to update 2 columns in table one. the two column to be updated are binary datatype and are updated based on

matching comparison between table 1 and 2 where the 2 columns are updated based on results from data in  

table 2 which is char datatype. in table 2 the results are listed as y or n for each column, in the table to be updated

the same data is listed as 0x01 = y and 0x00 = n.  
0
richa1960
Asked:
richa1960
  • 2
1 Solution
 
silaupuraCommented:
If u want to do this for update, delete or insert into any one of table, better u use stored procedures( SQL Server ).

if database is access then let me know.
0
 
richa1960Author Commented:
the database is in sql 2000, and the update is a one time adjustment.
0
 
silaupuraCommented:
Ok, stored procedures will do. let me know when u r done.

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now