Update Query - Multiple SETS and WHERE conditions

[weekend00]

Sorry, I cannot access my personal email during work time and not allow to expose my business email.

[jasonbarnes]

Here is this screenshot.

[weekend00]

They look all equal. but you need to check field by field to find out which one is not equal.

Based on my super carefully checking, maybe there is a space in the front of field ST in table tblbusinessrule1.

[jasonbarnes]

That has to be it! Before I imported I had to Text-to-Colum this entire set from Example_Example_City, State_Example and separate it. Now if I can just find a quick method to take the space out. Thank you so much. I can't believe you saw that from the size of that screenshot.

[weekend00]

I said I check it "super carefully" by measuring the space using a micrometer.

you can update the field:

update tblbusinessfule1 set ST=trim(st)

[jasonbarnes]

Now for some reason it wants to make me enter Parameter values for DestinationCity and DestinationState. #BUSRULE updates without a problem.

[weekend00]

seems like you type the field names wrong.

[jasonbarnes]

Nevermind, I got it fixed again. Darn spaces...I forgot how much I hated naming, login, spacing, and everything else associated with programming. I had relational database in about 2003 when I did Information Systems as my undergraduate degree. I went on to do my Masters in Accounting so they are wanting me to help out in all aspects with various projects. I am now a Financial Analyst.

[jasonbarnes]

Do you have any suggestions for making the Query run faster the 2nd, 3rd, 4th times through as I apply more BusinessRules to the data.

Didn't know if I could nest a Select Query with IS NULL on the DESTINATION CITY/STATE or #BUSRULE fields before I ran the WHERE conditions on the data.

[weekend00]

Please let me know if there is any position open. I am looking for a job. my specialty is IT, and I have worked in banks for many years.

[jasonbarnes]

I don't know where you are located. I am in North Carolina. I know some of the Regional Banks here are always looking for IT people. I saw lots of jobs here when I got out of Grad school but my experience was basically in school and was kinda dated by the time I got out. I was more interested in pursuing a Finance/Accounting Career. Two really good size regional/multi state banks are FirstCitizens and BB&T. Just google and go to their careers website. I know people in Corporate and Human resources at both to at least get them to look you over. I know an IT software company near where I live but they are more development type roles. Let me know if you need anymore help by sending me a PM.

[weekend00]

Thank you.