Two things. First, from the description provided it is really difficult to provide you with any real help. Second, why do you think you need a cursor? ...

gah (8/20/2009)

---

if you are saying that all customer / locations combinations should be in table CustomerLocation and you want to find the combinations that are "missing" then please try this

SELECT...

Half Bubble (8/20/2009)

---

I never think of union.

This isn't quite it either. I'm looking at 18 customers and 2 locations, so there should be 18*2 customerlocations. Your query finds me 2...

Not being mind readers or having access to your systems, can't really help you from here without more help from you. Please provide the DDL for the table(s) (Reduce...

setlan1983 (8/20/2009)

---

Lynn Pettis (8/19/2009)

---

This is just a simple left outer join:

select

entryt.EmpName,

entryt.EntryDateTime,

exitt.ExitDateTime

from

dbo.EntryTable entryt

...

Half Bubble (8/19/2009)

---

An SQL puzzle that's tripped me up. I wound up doing it brute force.

Simple Many to Many between Customer and Location. Intervening table is CustomerLocation. They are linked...

This is just a simple left outer join:

select

entryt.EmpName,

entryt.EntryDateTime,

exitt.ExitDateTime

from

dbo.EntryTable entryt

left outer...

Curious, base on other posts I am wondering what your position is with your company? Mind letting us know?

No problem. Guess I need...

Attached you will find some code that hopefully meets your needs. I have tested against your sample data, and it seems to work. I haven't had time to...

mm (8/19/2009)

---

You shouldn't be so gumpy Lynn... Remember back in the days when you were working on a problem and you just couldn't figure it out and your boss...

Hey, now I really like the avatar...

Don't you just love these? Of course when it starts, they don't bother to provide data that is represetative of the problem they are trying to solve.

You do realize we are volunteers with jobs of our own. We give of our time as we have time available. If this is a critical issue, seems...

Thanks Gail for jumping in on this one.