Typically, you're talking about two different elements you're going to need to learn. You'll need your front end (which would be ASP, .NET, C#, PHP or any of a...

It seems like I'm overlooking an easier way to do this, but here's *a* solution. I use the variables so that I don't have to recursively scan a static...

t1.patientnummer = t2.patientnummer

Is this a 1 to 1 relationship? It's hard to imagine that an update like this could take so long with a proper join.

And the fact that bitmaps are HUGE. Not everyone that checks these forums has a high speed connection, and regardless, it just seems so... 20 years ago, to me...

Interesting... I swore it worked when I ran it at the office. I don't even remember adding the WITH INDEX clause to the second piece. In any case,...

Now that the issue is resolved... Bitmaps?... Seriously? 😛

OK. This will be attempt #1 at a set based solution. I'm not 100% sure at the speed of this, as the index does not fully cover the...

Great image. That goes a lot farther towards explaining what you are after. This seems like it'll be a very interesting query to write. I haven't the...

I have CTE's down on my list of things to do some more research on, so this may be totally off base, but isn't that still going to return multiple...

Indeed. I'll have to wait until we decide exactly where we're going to go with it before I decide if I'm going to need dynamic SQL or not.

ggraber

---

BTW, I...

You're welcome. Glad I could help.

I don't disagree, I just don't see the necessity for the table. Checking the column data, considering it wouldn't be manually typed in is easily done just with variable...

I did, and it doesn't help me see how my solution wouldn't work, because the way I'm looking at it, you would still just do:

FROM ptAppointments P

LEFT JOIN coApptResources...

Then apparently I'm on the wrong track...

I should note, that I wouldn't necessarily use that as a final solution unless you had to. That should get the links right for the time being, but it'd...