Sfrgttk

Being asked to review a paper in conference one has submitted to

Would the melodic leap of the opening phrase of Mozart's K545 be considered dissonant?

Is there a math equivalent to the conditional ternary operator?

It doesn't matter the side you see it

I can't die. Who am I?

Draw bounding region by list of points

Is every open circuit a capacitor?

How to mitigate "bandwagon attacking" from players?

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

Is there any relevance to Thor getting his hair cut other than comedic value?

I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?

When was drinking water recognized as crucial in marathon running?

Difference between 'stomach' and 'uterus'

Can the Shape Water Cantrip be used to manipulate blood?

Can we carry rice to Japan?

School performs periodic password audits. Is my password compromised?

Deal the cards to the players

A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

How does insurance birth control work?

Specific Chinese carabiner QA?

Should I use HTTPS on a domain that will only be used for redirection?

Can I solder 12/2 Romex to extend wire 5 ft?

Find maximum of the output from reduce

Giving a talk in my old university, how prominently should I tell students my salary?

Subtracting sum of previous rows

0

I want to create total field in this table. But in SQL server 2008 can't use 'order by' in OVER clause.

I have same PO and difference INV. I want to Qty field minus Quantity field and next row Total field minus Quantity field.

This is my code but it's error at ORDER BY.

select t2.BaseRef 'PO',t2.BaseQty 'qty', t1.NumAtCard 'INV',

        t2.Quantity 'Quantity',

        t2.BaseQty - SUM(t2.Quantity) OVER (ORDER BY t1.DocDate) AS 'total'

from OPDN t1 

        INNER JOIN PDN1 t2 ON t1.DocEntry = t2.DocEntry 

Can I use other way for sort this data?

sql-server sql-server-2008 sql-server-2008-r2 running-totals

share

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I want to create total field in this table. But in SQL server 2008 can't use 'order by' in OVER clause.

I have same PO and difference INV. I want to Qty field minus Quantity field and next row Total field minus Quantity field.

This is my code but it's error at ORDER BY.

select t2.BaseRef 'PO',t2.BaseQty 'qty', t1.NumAtCard 'INV',

        t2.Quantity 'Quantity',

        t2.BaseQty - SUM(t2.Quantity) OVER (ORDER BY t1.DocDate) AS 'total'

from OPDN t1 

        INNER JOIN PDN1 t2 ON t1.DocEntry = t2.DocEntry 

Can I use other way for sort this data?

sql-server sql-server-2008 sql-server-2008-r2 running-totals

share

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I want to create total field in this table. But in SQL server 2008 can't use 'order by' in OVER clause.

I have same PO and difference INV. I want to Qty field minus Quantity field and next row Total field minus Quantity field.

This is my code but it's error at ORDER BY.

select t2.BaseRef 'PO',t2.BaseQty 'qty', t1.NumAtCard 'INV',

        t2.Quantity 'Quantity',

        t2.BaseQty - SUM(t2.Quantity) OVER (ORDER BY t1.DocDate) AS 'total'

from OPDN t1 

        INNER JOIN PDN1 t2 ON t1.DocEntry = t2.DocEntry 

Can I use other way for sort this data?

sql-server sql-server-2008 sql-server-2008-r2 running-totals

share

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

select t2.BaseRef 'PO',t2.BaseQty 'qty', t1.NumAtCard 'INV',

        t2.Quantity 'Quantity',

        t2.BaseQty - SUM(t2.Quantity) OVER (ORDER BY t1.DocDate) AS 'total'

from OPDN t1 

        INNER JOIN PDN1 t2 ON t1.DocEntry = t2.DocEntry 

share

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 47 secs ago

midtonightmidtonight

1

New contributor

midtonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 47 secs ago

midtonightmidtonight

1