I am assuming the solution is a correlated subquery.

Like this example, with the difference that you need to use sum and group by instead of AVG.

This must be done for...

my bet would be that you would want to use the LEAD() function and it's partitioning option of TSQL

If you order and partition your data by the colums that define...

• This reply was modified 6 years, 3 months ago by ktflash.

We need table structres of the tables used in your query and if possible the query itself.

Is the table having the End Date already used in the query? if not...

Hmm

Now i am struggling a bit on how to deal with TSQL Questions...

Are you looking for something like this?

SELECT JT.TRANSID
      ,JT.ITEMID
      ,JT.POSRECORDID
FROM JournalTrans JT
     inner...

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the time.

This sounds more...

I use the dark theme myself but for some things its so bad

One of them is MDX calucations in a cube, another one are the relations in dimensions

It is very...

How will the data be read most of the time? Since the clustered index defines data storage, I usually lean towards making the clustered index the most common access...

The idea with splitting sounds logical.

Why go for a clustered index in this situation?

Because the uniques granted through Material and Time?

I guess include is not relevant in this since the...

The issue i ran into somethimes is when 2 rows of a column in the Dimension have different Name Column values.

Example:

• AccountLevel0 = P&L

Name Column:

• Row1: AccountLevel0_Name = Name
• Row2:...

I am confused,...

I am confused, this sounds like...

and please use the "insert code sample" function next time

select much
      ,better
      ,code
from to_read

The...

The real question is for what purpose are you building an online persona.

I am just assuming, but if you are building an online persona for future job applications (which is...