Viewing 15 posts - 1 through 15 (of 98 total)
Following worked
SELECT TrId SellPrice kode DiffAmt,
sellprice+sum(DiffAmt) OVER (PARTITION BY kode
ORDER BY trId
ROWS BETWEEN UNBOUNDED PRECEDING
AND 0 PRECEDING)
February 23, 2023 at 10:54 am
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 ...
February 23, 2023 at 7:57 am
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,...
February 5, 2023 at 5:29 pm
what could be good and economical option on AWS ?
January 30, 2023 at 4:26 pm
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...
November 4, 2021 at 5:20 pm
Thank you. TRY_Convert exist in my version
November 4, 2021 at 10:20 am
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...
November 3, 2021 at 6:51 pm
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...
September 21, 2021 at 3:57 pm
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...
September 21, 2021 at 2:23 pm
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...
September 21, 2021 at 2:08 pm
No trigger on this table
Is there an insert trigger on WEB_ORDERS? Cursor could be lurking there.
September 21, 2021 at 1:49 pm
no , app is not calling it in loop, but this could call several times in a sec
September 21, 2021 at 1:48 pm
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...
September 21, 2021 at 1:14 pm
Thank you Phil.
but why the addition of "@myFlag <> 1)" make it work ?
(@myFlag <> 1)
OR
(
@myFlag = 1
AND name NOT IN ( 'A', 'C' )
);
DROP TABLE...
May 6, 2021 at 11:55 am
Viewing 15 posts - 1 through 15 (of 98 total)