Counts on different tables should be in different queries.

I think that you want something like this:

Select @CountHigh = SUM(Case When score Between 36 and 52 Then 1 Else 0 End)

, @CountHigh = SUM(Case When score Between 16...

No, I...

Jacob Pressures (9/10/2008)

---

I'm in DatabaseRole Object in BOL2005. it says, "This feature will be REMOVED in a future version of MS SQL Server. Avoid using this feature in new development...

but @encrypt is an optional parameter, you shouldn't have to specify it.

@encrypt = 'none'

NifflerX (9/10/2008)

---

I realize this thread has been quiet for some time but I've finally heard back from some of my providers. They had me try to run the stored...

How can we reliably tell whether a text Value is a product name or a comment?

Maybe there is a Delete trigger that is doing a Rollback?

And we are waiting for you to provide the requested table definitions and sample data. No one can reasonably tune 3500 lines of SQL without some...

Hmmm, over 3500 lines. Nice.

Please see this article on how to get better results from this forum: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hmm, I note that "seeing rows applied at the subcriber" is not necessarily in...

What Jack told you is...

Yes. I certainly have had multiple publications with Transactional Replication.

I like the powershell idea though, but I'm not proficient enough to evaluate it yet.