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

Posted on 2004-11-24
Last Modified: 2012-05-05
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.  
Question by:richa1960
    LVL 1

    Accepted Solution

    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.

    Author Comment

    the database is in sql 2000, and the update is a one time adjustment.
    LVL 1

    Expert Comment

    Ok, stored procedures will do. let me know when u r done.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article will show, step by step, how to integrate R code into a R Sweave document
    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now