We help IT Professionals succeed at work.

Help with update query

241 Views
Last Modified: 2010-03-20
SQL Server 2000.
I have the following query which runs fine:

UPDATE MASTER55
  SET API__bNumber = t2."EMP ID", [Has__bAPI__bMatch__bRun__Q]='Yes'

FROM MASTER55 t1
JOIN [API].LaborWorkx_Live.dbo.vwCGHS_All_EmpList t2
  ON t1.SSN = right(t2.SSN, len(t2.SSN) - 1)
 AND t1.L__d__bName = t2."Last Name"
 AND t1.F__d__bName = t2."First Name"
 AND t1.mrREF_TO_MR Is null
 AND API__bNUMBER Is null
 AND [Has__bAPI__bMatch__bRun__Q] Is null

However, I need to change it to achieve the following. I need the field [Has__bAPI__bMatch__bRun__Q] to be set to Yes regardless of whether a successful match is made between the EMP ID and API__bNumber. This [Has__bAPI__bMatch__bRun__Q] field will be used to tell whether or not the query has ran for that particular record, so it needs to be set to Yes each time the query runs, whether its successful or not in finding a match. Please advise. Thanks.
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
SQL SERVER DBA,
     I ran this code with 2 records, one where there was a matching API__bNumber, and one where there wasn't one. [Has__bAPI__bMatch__bRun__Q] was only updated in the record with the match. I need this field to be updated even if there is no match.

Author

Commented:
Please see my last post. Thanks.

Author

Commented:
Hello... anyone there?
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.