Ed Wagner (1/22/2016)

---

jasona.work (1/22/2016)

---

J Livingston SQL (1/22/2016)

---

Ed Wagner (1/22/2016)

---

J Livingston SQL (1/22/2016)

---

Ray K (1/22/2016)

---

whereisSQL? (1/22/2016)

---

Ed Wagner (1/22/2016)

---

crookj (1/22/2016)

---

djj (1/22/2016)

---

Ed Wagner (1/22/2016)

---

djj (1/22/2016)

---

J Livingston SQL (1/22/2016)

---

Luis Cazares (1/22/2016)

---

whereisSQL? (1/22/2016)

---

crookj (1/22/2016)

---

Ed Wagner...

limits

town

longest

not sure what version of Sage 300 you are running

but this table def for ICIVAL shows transdate as date

http://sage300.guru/AOM55A/ICIVAL.HTM

here is a start

https://msdn.microsoft.com/en-us/library/ms189461.aspx

am trying to find the source that demonstrates the efficiency of using "unbounded preceding"...I have it somewhere <grin>

will post back if I find it

ok...which bit?

is it the "CASE" statement or the "SUM OVER".....or ?

thanks...but do you understand how?

I do not see any transactional dates to determine an order......do you want all Bills to show before all Payments in a month?

EDIT....moving on with a possible solution

SELECT *,

...

Hi......if you could provide some scripts that give table structure / sample data / expected results (based on sample data)...then that will help us all.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

have you read this ....may help as additional source

http://www.sqlservercentral.com/stairway/72401/

michaeleaton 36224 (1/20/2016)

---

I'm trying to find all customers who have placed an order but there isn't a callback after their last order date.

There should always be at least one AccountCallbacks.CallbackDate...

possibly may get you started?

use TEMPDB;

SET NOCOUNT ON

CREATE TABLE #stockm(

productcode INTEGER NOT NULL

,QOH INTEGER NOT...

deja vu

http://www.sqlservercentral.com/Forums/Topic1696588-3077-1.aspx

can be found on this page (I used Google to find it)

http://msftdbprodsamples.codeplex.com/releases/view/55330