Huge Difference.  It only takes 3 seconds to run now.  I don't know why I didn't think of that.

Thanks all of you for your help.

select

distinct Clientid, dbo.concatFieldNames(clientID)Publication

INTO

#clientpublication

from

ClientPublication

I am doing this through a trigger.

Thanks

Database Mail is working fine.  I have other items using it.  Also I can't kill the transaction which is why I have to stop services.  Service broker isn't really an...

Try it this way with only one declare and commas separating your two variables

Declare @BeginDate varchar(8),

              @EndDate varchar(8)

Select @BeginDate = convert(varchar,DateAdd(mm, DateDiff(mm, 0, dateadd(mm, -2, Getdate())),0),112)

Select @EndDate = convert(varchar,DateAdd(mm, DateDiff(mm,...