Can you describe in details what happens when...

Duplicate question. Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1337693-391-1.aspx

Perhaps a security issue?

How is the security configured on the datasource?

Any errors when you try to browse to Report Manager?

You can try this:

WITH CTE_TableA AS

(

SELECT AggregateKey = COALESCE(ParentID,ID), JoinKey = ID

FROM tabA

)

SELECT ID = A.AggregateKey, Value = SUM(B.Value)

FROM

CTE_TableA...

You're right, I made an error in my code. Note to self: drink more coffee 🙂

shashi kant (7/31/2012)

---

Hi SQLNavie,

I achived the solution using Cursor query. Please find below query

Declare @tempTable as table(id int, value Int)

Declare @value as int

DECLARE @CUR AS CURSOR

SET @CUR...

You apparently added a Tablix but didn't specify a dataset.

If your hierarchy is only one level deep as in the sample data:

WITH(CTE_TableA) AS

(

SELECT JoinKey = COALESCE(ParentID,ID)

FROM tabA

)

SELECT ID = A.JoinKey, Value = SUM(B.Value)

FROM

CTE_TableA A

INNER JOIN

...

Very nice question. The 2012-version of BOL isn't really clear:

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

but the 2008R2 documentation is pretty specific:

Backup compression was introduced in SQL Server...

You can find some 7zip command line examples here:

http://www.dotnetperls.com/7-zip-examples

GSquared (7/26/2012)

---

You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the...

The Execute Process Task is the SSIS equivalent of executing a process through the command line.

chaithu559 (7/27/2012)

---

Hi Everyone,

...

At first sight I would look into the UNPIVOT operator:

Using PIVOT and UNPIVOT