Can you post the whole stored procedure Jorge?

Here's version 2 Gareth, with an extended sample data set.

-- test data --

DROP TABLE #wms_requirements

DROP TABLE #wms_batch_queue

CREATE TABLE #wms_requirements

(

[warehouse] [char](2) NOT NULL,

...

AND a.History_YN IS NULL

The opposite would be:

AND NOT a.History_YN IS NULL

or

AND a.History_YN IS NOT NULL

If you want to compare your column with a second literal, then it might...

SELECT a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

,d.history_YN

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID = b.CLIENT_ID

inner join FRATERNAL.CLIENT c on a1.CLIENT_ID = c.CLIENT_ID

WHERE a.CONTACT_TYPE_ID in ('Email1')

AND b.MEMBER_NUMBER...

Which table contains the column HISTORY_YN?

The legendary Linda Lovelace apparently said something similar.

The Y is a literal, and as such requires...

SELECT

a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID = b.CLIENT_ID

inner join FRATERNAL.CLIENT c on a1.CLIENT_ID = c.CLIENT_ID

WHERE a.CONTACT_TYPE_ID in ('Email1')

AND b.MEMBER_NUMBER...

:w00t:

Some of the recent questions might have been better marked "burn before reading"!

lmu92 (1/20/2010)

---

Gianluca Sartori (1/20/2010)

---

...

Well, I can say that I had a...

Your character string - your query - is missing the closing quotation mark.

Hey Gareth

The solution I've posted above works, but looking at it I can't help thinking of one of Jeff Moden's mantras - make it work, make it fast, make it...

CREATE TABLE #wms_requirements

(

[warehouse] [char](2) NOT NULL,

[product] [char](20) NOT NULL,

...

Hi Biz

Can you please run the following code and identify those rows which you call Duplicates?

I've rehashed the sample data so that it's now a temporary table.

-- Set up sample...

Some articles are well worth reading twice.

I've spent all afternoon working for the first time with EXCEPT instead of the usual LEFT JOIN and checking for NULL, and it's taken...

Kit G (1/18/2010)

---

Chris Morris-439714 (1/15/2010)

---

Hello

The UPDATE and the SET apply to the same table.

Ideally the first table listed after FROM is also the target of the update.

In your case,...