You can always set the degree of parallelism to 1 if you are having problems with particular queries. We use it sometimes.

Example:

SELECT

*

FROM

Orders

WHERE

...

I believe the only way you could do this is to either:

1) Add or alter the current report parameters to be data driven and then set the parameter properties so...

It may sound crazy (like it did to me at first) but YouTube is a fantastic resource for online video tutorials on all sorts of SQL Server related technology. Have...

We need the DDL code before we can comment really but it should be reasonably straight forward if your 'starttime' is a DateTime datatype.

Something like this should do it:

WHERE starttime...

Hi,

I too am just starting out with SSIS. The tutorials i've been working through are these:

http://msdn.microsoft.com/en-us/library/ms167031.aspx

You may find that of some use. Are you sure that SSIS is the tool...

Hi,

Change your select statement to have the following:

;

WITH cte

AS ( SELECT

...

Does it now always fail at this step or is it just sometimes?

We've seen a problem recently with xp_smtp_sendmail being unable to run on SQL Server 2008 64 bit edition....

Perhaps if you posted the procedure and some sample data we might be able to help you?

SELECT ( CASE yourDate

WHEN 'January' THEN 1

...

You could always include a call to xp_smtp_sendmail see below...

DECLARE @ERC INT

DECLARE @EmailFromAddress VARCHAR(100)

DECLARE @EmailToAddress VARCHAR(100)

...

Be careful if any of your data fields can be NULL -> it will make the entire result NULL. In that case you should wrap the column as follows:

ISNULL([AddressLine1],'')

You can...