Actually its not so much that but the difference between an Execute SQL Task...

In this case the error message means exactly what it says. In general, when you have aggregates (like the SUM() function in your query), you have to list *all*...

Here's one way that might do it:

DECLARE @Pct float = .25

DECLARE @maxID int = (select max(ID) from #TesteTable)

MERGE INTO #TesteTable a

USING (

SELECT ID, Duration, A+A*@pct as...

Try commenting out the first "order by" clause. It makes no sense to order the data before UNION anyway

Right, The local variable type is Int64. However, what is the parameter type (in the SQL task Parameter Mapping tab.) IN your case, that should be LONG, I...

Are you passing the parameter as an integer (e.g. LONG)?

One advantage is that Select...Into can lock the database until the insertion is completed.

FWIW I sometimes go with this:

-- Step 1. Create target table

select <whatever>

into #target

where 1 = 0

...

--...

Dominic Gagné (4/11/2014)

Let's say I have a query like:

SELECT * FROM Table1 T1

INNER JOIN Table2 T2 ON T1.ID = T2.ID

INNER JOIN Table3 T3 ON T1.ID = T3.ID

LEFT JOIN Table4 T4...

Sure you can do it. You'll need to join on a subquery that gets the max datetime value

See my Post #1560145 above

1. Look at the query plan for any table scans and try to restate your query to avoid them

2. Add indices to match the columns you join or search on.

3....

Your second select is missing a comma:

SELECT '', 'SB9104520001', '2010-05-24', 'GLD', '8058581', NULL 'USD', '40122.00', '4251'

There should be a comma between NULL and 'USD'

Also, your ddl specifis that the column...

Lots of good resources, starting MSDN:

Brent Ozar:

http://www.brentozar.com/sql/table-partitioning-resources/

MS SQL Tips:

http://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

Mark Chapple:

http://databases.about.com/od/sqlserver/a/partitioning.htm

MSDN Blogs:

http://blogs.msdn.com/b/manisblog/archive/2009/01/18/easy-table-partitions-with-sql-server-2008.aspx

...and many, many more!

What's wrong with 1.3 seconds?

Seriously though, be sure you have indices on the join columns. Pre-aggregate the minimum calculations do reduce the join rows.

You're still rendering it directly as text. I think its better to return a float and let SSRS format it according to the formatting you set up. Also,...