Steve Jones - Editor (10/5/2009)

---

I miss anything? Just cranky old guys and gals complaining?

The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than...

No, Gus, wasn't taking you serious on point 1, not after what I read about it. Re point 2, I'm reading up on the link you sent. Looks pretty scary...

GSquared (10/5/2009)

---

jcrawf02 (10/5/2009)

---

My project this weekend has been Artillery Fungus[/url], unfortunately. I'm trying the mouthwash/toothpaste solution on that link later tonight or tomorrow, depends when it rains. Spent time this...

Was just asking because they guy who "advertised" his free tool, just to get some feedback a few weeks ago (forgot his name and exactly what it was) got bitterly...

Is this fair use of the forums by the way?

Oops, didn't read original post properly. Rest of post removed. Apologies...

Hey, I liked Seth's reply to this one. You, Lynn, were way too saintly again.

Hi Steve,

I'd say first prize would be if you could get the extraction to populate the ClassStart/EndDate columns correctly in all cases. May be easier said than done, I know,...

Hi Steve,

It is a bit late (in this part of the world) to wrap my head around you problem, but what first comes to mind is that your table is...

I agree with you Steve in terms of the amount of auditing done, but I guess it also depends on how wide your tables are. Duplicating the most recent records...

Now how do you like the OP's reply to Lutz's suggestion on this one http://www.sqlservercentral.com/Forums/Topic793490-1291-1.aspx

Steve-437536 (9/24/2009)

---

Thank you both, that's what I figured. It gives me another reason to ask that we put a primary key on the table, as I didn't find any...

UB-242988 (9/25/2009)

---

After I wrote all my thoughts into this question/post and re-read it, approach 2 seems like a better one. The small over head is negligible. Is one more row...

Hi Michael,

Don't want to give away the answer, because the whole point of these forums is to teach people how to teach themselves. Just a hint, a simple LEFT JOIN...

Hi Stuart,

Try this:

CREATE PROCEDURE usp_GetEmailsOnCall

@EmailsOnCall varchar(max) OUTPUT

AS

BEGIN

SET @EmailsOnCall = 'fred.smith@domain.com;joe.bloggs@domain.com' -- Replace this with actual code to get email adresses from database table

END

GO

DECLARE @EmailsOnCall...