Hi Srikant,

Thanks again for a quick reply but your query still doesn't return correct results.

It shows me "Chief Executive Officer" = 0 which means that there are no more children...

Hi Srikant,

Thanks for a very quick reply. If I get this correctly, your query gives me the path instead of my sortkey.

However what I want along with the SortKey is...

Hey thanks mate 🙂

Seems like I need more tea! Appreciate it.

Point taken mate 🙂

Next time onwards I will post an insert query to get more answers.

Thanks Craig and ColdCoffee. I will stick to what originally worked a while ago. I have tons of other dashboards to do and I will leave the performance aspect to...

Thanks Craig.

I have modified it a little. TOTAL needed to be excluding today as it mentions in the column header of the example data in the first post so AVG...

Thanks Craig.

I am also looking and searching myself and reading this http://www.sqlservercentral.com/articles/T-SQL/63681/

The query below seems to work. I am still working on the TOTAL and AVERAGE columns.

SELECT MatrixName,...

Sure. I am not sure if this is what you want but here you go.

WITH Rolling5Summary(MatrixOrder, MatrixName, OriginalDate, [DayOfWeek], TotalCount)

AS

(

SELECTCASE keyMatrix

WHEN 'E4B59C9E-FE52-4038-A08B-1BF5958FFB89' THEN 1

WHEN '6FD750DC-128D-4440-ADAE-695927C1C2E9' THEN 2

END AS [MatrixOrder],

CASE keyMatrix

WHEN...

APOLOGIES ABOUT THE DOUBLE POST... THE WEB BROWSER DID IT!

APOLOGIES ABOUT THE DOUBLE POST... THE WEB BROWSER DID IT!

Thanks guyz. I had a feeling that this is the case. I just didn't wanted to start out upgrading the production server since we are still testing the code on...

OK I just updated the SQLBase to 9.0 version of the Server and the same error..! Yikes.

Is the SQL Server service running?

Can't go wrong with this one.

http://www.microsoft.com/MSPress/books/9615.aspx

Hi thanks for the quick reply. I was trying to...