insert and updates to table are high. also re-creating columnstore will impose locks on table and that table is high in use. such activity could impact a lot 🙁

Yes it worked :):)

Following worked

SELECT TrId SellPrice kode DiffAmt,

sellprice+sum(DiffAmt) OVER (PARTITION BY kode

ORDER BY trId

ROWS BETWEEN UNBOUNDED PRECEDING

AND 0 PRECEDING)

Yes,on group of TrId and Kode, like illustrated below

TrId SellPrice         kode          DiffAmt     Rtotal (sellprice+DiffAmt)

1        27560.5010  3000276    0.5000    27,561.001 (27560.5010+.5) (sellprice+DiffAmt where trid=1 and kode= 3000276)

2       27560.5010 ...

thank you All for valuable  directions. I will try to follow correct path as suggested.

one more question about locking, OFFLINE rebuild lock table for upcoming transactions. What about current transactions,...

what could be good and economical option on AWS ?

sure sir.

following is my proc code. proc is taking comma separated input string . it get parse and then compare to db table. if product(s) are invalid , i sent...

Thank you. TRY_Convert exist in my version

Thank you All for input.

issue is resolved, it looks like ODBC issue but really not sure.

we added connection open/Close on every sql statement in application and apparently it looks fixed...

Dev said he used default settings. I got following on login Audit (profiler), not sure if this can help

-- network protocol: TCP/IP

set quoted_identifier on

set arithabort off

set numeric_roundabort off

set ansi_warnings on

set...

This part of application is developed in Omnis

I need to confirm ODBC version, Yes windows server upgraded some time back

What type of application? MS Access by chance? I do...

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

This table has no FK constraint , as this is base table and having PK only

It's just an INSERT for C.R.U.D.  I suspect that the inset is sometimes being...

No trigger on this table

no , app is not calling it in loop, but this could call several times in a sec

I have not defined any cursor. But may  be it is throwing error due to implicit cursors by rdbms , that is the reason for suggestion about SET NOCOunt ON...

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