Could be hardware. What is the currently load in Task Manager and shutdown any services such as Virus Scan while installing and those you don't expressly need that are eating...

A few other factors that get overlooked a lot or OUTPUT paramters. Many times I will do an insert or update and not care to get a recordset back so...

Glad could help, sorry thou took me so long to realize what was going on in the query with the ANDs and ORs.

Oops I see the issue now. Silly me if you do this

WHERE

 (ExpiryDate != '20040630' AND CONVERT(varchar(10), InsertDate, 112) != '20040310') AND

 (ExpiryDate != 'Edate2' AND CONVERT(varchar(10), InsertDate, 112) != 'Idate2')...

Try

ORDER BY

CAST(column AS varchar(10))

Which is better is not a real point Andy. What matters is for this situation which works best. You still have to test each. All should be considered alternatives and...

Just another option

UPDATE

 T1

SET

 MinDate = T2.MinVal,

 MaxDate = T2.MaxVal

FROM

 WT_Total_Purchases T1

INNER JOIN

 (

  SELECT

   optioneekey,

   offeringperiodkey,

   min(create_dt) MinVal,

   max(create_dt) MaxVal

  FROM

   WT_ESPP_FACT

  WHERE

   eventkey IS NULL

  GROUP BY

   optioneekey,

   offeringperiodkey

&nbsp

From SQL BOL

The SQLVerify method does not perform a restore of any SQL Server database or transaction log.

To the best of my knowledge without building an app real quick, it...

If you do

select * from tempdb..syscolumns where [id] = object_id('tempdb..#temp')

after your alter you will see the value has been updated to rflect the third column.

What I believe is happening is...

SOrry see your point should be

WHERE

 (ExpiryDate != '20040630' AND CONVERT(varchar(10), InsertDate, 112) != '20040310') AND

 (ExpiryDate != 'Edate2' AND CONVERT(varchar(10), InsertDate, 112) != 'Idate2') AND

 (ExpiryDate != 'Edate3' AND CONVERT(varchar(10), InsertDate, 112) !=...

Actually I think the where would be more like

WHERE

 (ExpiryDate != '20040630' AND CONVERT(varchar(10), InsertDate, 112) != '20040310') OR

 (ExpiryDate != 'Edate2' AND CONVERT(varchar(10), InsertDate, 112) != 'Idate2') OR

 (ExpiryDate != 'Edate3'...

Can you walk me thru how you set up each step and how the next query is determined?

Also is the next tasks query changing in any way?

1) Look at the @@ROWCOUNT variable.

In you QA code add SET NOCOUNT ON to the begin. Delcare a variable of a large enough numeric type (most likely int will work),...

To take a little further you can create a base role and and exteneded role which is also a member of the base role. Example where this would be seen.

HR...

You cannot do this with an Execute SQL Task in general cases. However what is it that is it you are actually after? Number of record affected, the data returned...