something like this would get you started on a set based solution:

with sp_lines(ObjectId, SPName, CRPos, [LineNo])

as (

select

o.id

,o.name

,t.n as CRPos

,ROW_NUMBER() over (partition by o.name order by t.n) as [LineNo]

from sys.syscomments...

In all my years of writing database code, the only times I have ever opted to use cursors is when executing a parameterised statement across different servers or databases. ...

Unfortunately not...I moved on to other complicated things and left that problem to stew on its own for a while 😉

Any takers?

Hi Valli,

I think you have understood pretty well, I'll try to clarify:

assuming we have a field in the data warehouse called MAT.

Create two measures using MAT, one using Sum and...

I have to do the same calculations in our business. I opted for doing the calculations in the cube instead of the warehouse. It performs very well.

I think...

You can't create calculated fields in Excel when using a cube source (as far as I'm aware), you would have to create a a new calculated measure in the cube...

Good effort Gaby but I agree with all the other posts! I tried this method a couple of years back (I've always been anti cursors) but found that the...