Ygthkb

Quitting employee has privileged access to critical information

Is there a math equivalent to the conditional ternary operator?

Ahoy, Ye Traveler!

How to kill a localhost:8080

Why did the Cray-1 have 8 parity bits per word?

How can I be pwned if I'm not registered on the compromised site?

How to disable or uninstall iTunes under High Sierra without disabling SIP

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

Is there a full canon version of Tyrion's jackass/honeycomb joke?

Why won't the strings command stop?

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

Can we carry rice to Japan?

Formatting a table to look nice

Meaning of word ягоза

I encountered my boss during an on-site interview at another company. Should I bring it up when seeing him next time?

How to fix my table, centering of columns

Was it really inappropriate to write a pull request for the company I interviewed with?

Book about a time-travel war fought by computers

Canadian citizen, on US no-fly list. What can I do in order to be allowed on flights which go through US airspace?

Sometimes a banana is just a banana

How can I handle a player who pre-plans arguments about my rulings on RAW?

How does signal strength relate to bandwidth?

Correct physics behind the colors on CD (compact disc)?

PTIJ: Aharon, King of Egypt

Subtracting sum of previous rows

Subtract next row's datetime with current row's datetime based on conditionPerform Sum In Update StatementSubtracting sum of previous rows' data from current row's data in SQLCompute the total of SUM(column)Create a view showing total minutes per customer per month and change from previous monthUse SUM With Update & CTEAVG using specific condition for each rowHow to limit the number of rows in select statement for a condition in sql server 2012Update Top 1 Row In SQL ServerGroup by sum based on under group in SQL Server

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 2 mins 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 2 mins 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 2 mins 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 2 mins 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 2 mins 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 2 mins 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 2 mins ago

midtonightmidtonight

1