Thank you.  That did the trick! 

Got it.  I made the corrections in my code and it's working like it should.  You guys are great!   Thanks for all...

I see.  The query:

where p.vendor_code NOT in

(select p.vendor_code

where p.vendor_addr_l1 is null

omits any customer who has all those fields NULL.  It works the same wether I put 'from dbo.pocvnms'...

I noticed at looking at the output when I ran your code and I'm seeing duplicates, which would explain the additional rows:

100032      NID PTY LTD   18 STROKES AVENUE      2006-07-31 00:00:00

100032      NID PTY...

Now I'm getting two different results

When I run yours, I get 3,147 rows.  When I run mine:

select p.vendor_code, p.vendor_name, p.vendor_addr_l1, p.vendor_addr_l2, p.vendor_addr_l3, p.vendor_addr_l4,...

Sorry, that was a typo.  I do not need the a.date_payment in the result set.  I used the max(a.payment_date) and did a group by for all the other columns and...

Well, I tried it

(and a.date_payment = (select max(a.date_payment) from dbo.appayrh

where p.vendor_code = a.vendor_code)

and got an error:

Server: Msg 147, Level 16, State 2, Line 1

An aggregate may not appear in...

Thank you Aaron!  That worked perfectly.

Isabelle

Hi,

I got it to work by running the following:

EXEC

sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC

Hi,

I am logged in as the admin account and get this error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ','.

Msg 15123, Level 16, State 1, Procedure sp_configure,...

Thanks.  I did not a spot check here and there and it seems to be working the way its supposed to.

Isabelle

Hi Pam,

Yes, we are going to a new ERP system that will take care of the constraint issues and we are currently getting ready to migrate the data to the...

Great article.  I have been fortunate with the companies I have worked for and have had a lot of training and opportunities to attend conferences/seminars.  My challenge in my development...

Wow, what a great editorial.  I have to say that as a 38 year old mother of 4 boys, I have alot to be grateful for.  I spent alot of...

Thanks for the info! In my experience with Oracle, I found it better to learn by experience.  When we first went live with Oracle, they sent me to a bunch of...