Getting certifiied may help but from someone who read the Joe's to Pro's series, don't use it exclusively. They cover a lot and the cost of the books are...

Either that or you need to us the variable outside of the quotes if it holds a dynamic value.

Mark

Good info, thanks for posting it.

Mark

I believe "if exists" has to be used in the where clause and that's causing the issue.

Remove everything after your CTE and try this:

declare @intCount int

select @intCount = (SELECT count(*)...

Pinal Dave has a brief overview of setting of DBMail:

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

There's a part aat the end about sending a test email. That should verify if it's set up correctly.

Mark

Make sure named pipes is enabled. That and install any SP's.

Mark

Post the query you're working in and we'll take a look at it and advise.

Mark

Thanks for all the links. I'll read them later this evening when I get home.

Thanks,

Mark

DECLARE@Student TABLE( StudentName VARCHAR(50), Question INT, Answer VARCHAR(50))

INSERT@Student

SELECT'StudentA' StudentName, 1 Question, 'some' Answer UNION ALL

SELECT'StudentA', 2, 'thing' UNION ALL

SELECT'StudentA', 3, 'any' UNION ALL

SELECT'StudentA', 4, 'thing' UNION ALL

SELECT'StudentA', 5, 'every thing'...

J Good (6/28/2012)

---

Another book I recommend is SQL Server 2008 Administration in Action by Rod Colledge. It has a lot of practical techniques, best practices, and even a recommended work...

I think the only one that can really answer that question is the original developer.

Mark

You may not need the temp table. In fact, the query seems rather complicated for what you're trying to do.

I created 2 tables to test this:

Headers

----------------

HeaderID (PK)

Header ...

Patrick,

Thanks, I'll check them out!

Mark

All these replies got me wondering about the role of the PostID and I decided to add it to CTE and this worked:

with ThreadTable(ThreadID, MaxPostID, ThreadCount)

as

(

select top 5 FP.ThreadID, max(PostID)...

All,

I'm still getting numerous records per ThreadID when I'm only interested in 1.

I'll keep at it and appreciate all the suggestions.

Mark