Roy Ernest (3/24/2009)

---

Hahahaha Lynn, Maybe you should not have put Drop Table statements in the end. :hehe:

Maybe you should edit your post and state that you should not use the...

Charles Kincaid (3/23/2009)

---

Ah. :sigh: I don't like multiple monitors. Get the geometry wrong and you can have stuff positioned between them. I had a coworker fight that for...

My setup is actually using a...

Multiple monitors, definitely. I currently use 4, 3 hardware and 1 'software'. A few years ago I bought a little client-server application called MaxiVista which allows me to use any...

drewsx2 (3/20/2009)

---

Thanks Derrick!

Thnank Barry!

That works but when I update any other column in that row still executes the email procedure which is fine because the @emailTo is null.

New problem. It...

It looks like The Rant has run its course.

And from his description of his setup (sync software + 3 application tools + 5 databases), I don't think changing things would...

mazzz (3/20/2009)

---

Is that Sainsbury's, UK?

If...

Lynn Pettis (3/19/2009)

---

Derek Dongray (3/19/2009)

---

Anyway, while I'm willing to offer some 'keyhole' fixes, I don't want to argue over a redesign of someone else's system (especially as they aren't paying...

I'd do this as a JOIN ...

SELECT

@EmailTo = i.Name,

@EmailBody = @EmailBody + CASE ISNULL(v.LastName, '')

...

I'd do this as a JOIN ...

SELECT

@EmailTo = i.Name,

@EmailBody = @EmailBody + CASE ISNULL(v.LastName, '')

...

Lynn Pettis (3/19/2009)

---

Whoa! I think we had an epiphany!!! From The Rant:

foxjazz (3/19/2009)

---

Lynn, you have completely and utterly convinced me to look for a set based solution to...

Thanks, Barry.

Like Lynn, I'd used this trick but not really understood all the details of how it worked. Your explanation is very clear.

Bob Hovious (3/19/2009)

---

I presume it was the first statement.

What I know of chaos theory leads me to disbelieve the concept of "Temporal Inertia", although conversely it leads me to believe...

In...

Grant Fritchey (3/19/2009)

---

I left out a few things:

Cricket bat, hockey stick, bludgeoning devices of all kinds, light sabre's, blasters, fiber optic laser beam assemblers, fiber optic laser beam disassemblers, death...