Duplicate post. Other one found here: http://www.sqlservercentral.com/Forums/Topic556124-1063-1.aspx

How are you getting the results into the email? Are you attaching query results? Please post your current code. My best guess is that you would have...

Cross post. Please answer here: http://www.sqlservercentral.com/Forums/Topic556171-338-1.aspx

I don't know of any. I'd start by writing the new sp and compare results for Execution plans, statistics io and statistics time. I'm not really a .NET...

What does your execution plan look like? Based on what I can see of the criteria I don't really see a better way. The only thing you might...

As amit has said performance largely depends on design. I don't think, and I have done no testing, that a self-join will perform any better or worse than a...

I think Jeff liked that post he wanted to be able to find it easily in his list of posts.

This is a Running Totals problem. Check out this article, http://www.sqlservercentral.com/articles/Advanced+Querying/61716/.

I like the distributed partitioned views idea as long as there is something valid in the data to partition on.

The simple step is to use an if and query the...

Right, that's what I get for posting at 3am my time!

Use a variable. Something like:

Declare @success bit

Set @success = 0

If @nsqlver < 9.00304200

begin

print 'Wrong Server Edition'

print ''

print 'Current Serverversion: '

...

Good article Andy. Wish I'd had it a month ago when I was first trying to figure out how to use Execute SQL Task with a result set. ...

Huh? So it the rectangle one cell or multiple...

The screenshot you attached does not really tell us much. Are each of the rectangles a different cell or textbox?

Check out this article, http://www.sqlservercentral.com/articles/Reporting+Services/Santa+gets+an+RDL+present/61782/, I think it may help...

From BOL:

Diagnosing the Problem

The Database Mail external program logs e-mail activity in the msdb database.

First, use the SQL Server Surface Area Configurationutility to confirm that Database Mail is enabled....