Something like this:

DECLARE @String VARCHAR(1000);

SELECT @String = 'John Smith reports to Jane Smith';

SELECT LEFT(@String, PATINDEX('%reports to%', @String)-2);

Are you setting up the e-mails inside the plans, or in the jobs? I set that kind of thing up in the job, and it does what you'd expect.

Okay, I'll bite. When did you upload yourself? 😀

Wow! They actually made it feel like a business request. They actually left one of their "requirements" completely undefined and about as clear as lead. Requirement 1...

Is the "ID" column from another table that lists the valid values? If so, that makes the query a little bit simpler.

Last time I looked, Wikipedia had good articles and examples for Normalization and the various Normal Forms. It's really more than can be explained in a simple forum post.

The...

Lots of people will resolve to lose weight, or exercise more, or stop smoking, or spend more time with their family, or work smarter/harder so they can get a promotion/raise/job,...

You're welcome.

(By the way, "SSCrazy Eights" is a title based on the number of posts I have. The screen-name is above that, in bold. Same as yours.)

Michael Valentine Jones (12/24/2010)

---

Some people just don't take criticism well, no matter how nice you try to be about it, and things can quickly get nasty.

I tried to just stick...

Same to you and more of it! 😀

You'll want to join the table to itself based on a start date being less than the end date. Right?

Index is copied from old Vladivostok telephone directory...

DateDiff, as already mentioned, only counts date boundaries crossed.

You'll get 1 if you query the datediff(year) for 1 second before midnight, on 31 Dec, and midnight, 1 Jan, because the...

I have to say that my response to bad advice depends on where it is, what it is, what it's about, the tone it's delivered in, and the history of...

Glad I could help, even if it was in a limited fashion.