You need to specify "Variable" as SQLSourceType property of the Execute SQL task...

UPDATE A

SET A.LocationCode = B.LocationCode

FROM tableA A INNER JOIN tableB B ON A.id = B.id

Though the solution provided thegreatsamarth is correct, but i doesn't recommend it usng cursors, as this is row-by-row process and would probably be slow in execution...

And my solution is absolutely...

Check for the system table sys.fn_my_permissions OR sys.fn_builtin_permissions

SELECT * FROM sys.fn_my_permissions( NULL,'database' )

; WITH Customers

AS

(

SELECT ROW_NUMBER() OVER( PARTITION BY AccountNum ORDER BY AccountNum ) AS RowNumber, *

FROM Cleansing.Customer

)

UPDATE Customers

SET Group_Acc = RowNumber

I ran the test on SQL 2K5 SP2 EE & surprisingly got similar results that of the original poster..

And also, checked the execution plans, they look exactly similar to each...

Toggle "Ctrl + R"

Are you working with two different databases? I could see that the select is querying in sample1 database.

What edition of SQL Server do you have?

Try enabling OLE Automation in Surface Area Configuration Manager.

Excerpt from BOL:

You must be a member of the sysadmin role to create and manage maintenance plans, and to view them in Object Explorer. The SQL Server Agent node in...

SELECT H.HatID, H.HatName, MAX( His.InspectedDate ) AS LastInspectedDate

FROM tblHats H

LEFT JOIN tblHatHistory His ON H.HatID = His.HatID

GROUP BY H.HatID, H.HatName

Is this what you require?

UPDATE dbo.ADate

SET ADate = ( CASE

WHEN MinDate >= Start_Date AND MinDate <= End_Date

AND FPeriod >= Start_Date AND FPeriod <=...

As simple as it looks like....

SELECT OBJECT_NAME( @@PROCID )

Unfortunately, there isn't any option to set scripting options for the selected object. You'd only have to take what the SSMS gives you by default. However, you can...

Since your aggregating rows only for specific date, you don't need a GROUP BY clause.

Now for your query, you need to add sum aggregate to the query as

SUM(CASE WHEN...