Could this be part of the problem? There's a huge difference between estimated and actual number of rows.

Can you post table, index and views definitions?

My guess is that your problem is with dbo.AGGR_DAY_SUBSCRIPTION_ADDITIVE_METRICS_V. But can't be sure.

I agree with Gail, no one will look at a report...

This is another option that might perform better considering that it reads the table once instead of twice. I can't assure that but it could be worth the try.

SELECT ISNULL(CAST...

There might be a problem with your data and you might have duplicate ids on either of your tables. A quick solution could be the following but it might not...

You're comparing strings (LEFT result) with integers. Due to implicit conversion, the strings are being converted to integers and generating an error. Just add some quotes to convert your integers...

Except that Oracle will auto commit a transaction with any...

Or maybe you could filter the columns with a condition. I'm not sure if it'll be better.

SELECT column1,

column2,

column3,

...,

...

This might not be the correct version (I'm not sure if there's one for 2014) but it can help you out.

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145

You could also read some of the stairways in this...

This seems horrible because of the triangular join that it includes, but it might get you what you need without dynamic sql. Why are you duplicating the rows? Would an...

Using a CTE is basically the same but in different order. I prefer this approach but it's just personal preference.

ALTER VIEW [dbo].[crvKCLPRInsJob]

AS

WITH CTE AS(

SELECT

...

Hi Rodrigo,

Craig has a point and we might need more information. The following query works with the sample data but might not be exactly what you need.

SELECT *

FROM #item

ORDER BY...

Or you can use Import/Export wizard (or SSIS) to transfer the data in batches.

That isn't policy compliant, it needs to be P4$$w0rd as shown on MS courses.

Using some guesses, this might help you to read the table just once and do the pivot at once.

SELECT T0.ItemCode AS 'Item Code'

,T0.ItemName AS 'Item Name'

...

Readers don't block readers. Readers can block writers and the other way around. Even on that case, it would depend on the locks acquired based on the queries and the...