Hi Jonathan

Yes, you could use ISNULL to swap null values for "unrealistic" integer values for your ID's, so that the test would fail. However, if any of your ID parameters...

Hi smv

I'm using linked spreadsheets and doing updates, but the principle is probably the same - use a template spreadsheet and ensure that the columns you want numeric, are formatted...

Reckon Jeff's right.

Try this...

Select b.Col1, b.Col2, a.Col1, a.Col2

from Tab1 a join Tab2 b

on a.Col2 = b.Col2

... don't think you will find any rows where b.Col2 and a.Col2 don't match.

Then find...

Many thanks for your prompt reply, Rich. Both checked and negative.

Cheers

ChrisM

No kidding Mr Polecat, nice result.

Hi Mr Polecat

Do you need columns other than uid2 in your inner derived table?

update tb_leadbox

set invalidflag=6

where uid2 not in

(select min(uid2) as uid2

from tb_leadbox

where entrydate >= dateadd(dd,-365,getdate())

group...

Paul

I posted the general locale earlier in the thread. Matt says it all (thanks Matt!)

Cheers

ChrisM

Hi Robert

Have you tried "WHERE NOT DELETED()" in your query?

Cheers

ChrisM

Many thanks Steve, and thanks for the feedback Brandie.

Cheers

ChrisM

Brandie

You're absolutely right - I certainly hadn't considered the legal angle.

My post to the interviewer is exactly as above apart from blanking the names. The company has hired several times...

I'm not sure how relevant this is, but it kinda fits so here goes.

At a recent interview for a 6-month gig with a financial company, I was asked to...

Neigh, lad.

Spot on, Will, that's the answer my interviewer was expecting two weeks ago - even though round manhole covers are rare over here in the UK - in fact I'm...

Just had a quick play with this, here's the content of a sample text file:

Seller UserId: NO MATCHING DISBURSEMENT!

Business Name: NO MATCHING DISBURSEMENT!

Order ID: 166118

Seller UserId: C544068076250756   

Business Name: EOM-PHILLY...

Chris

Any feedback? What's your final solution?

Cheers

ChrisM