Viewing 15 posts - 1 through 15 (of 31 total)
Under normal conditions, when a row goes negative, the query lists the rows before that row.
However, if a movement has never been negative, it does not bring the relevant...
August 9, 2022 at 6:34 pm
Non-negative Id not coming?
What would be the reason
ıd = 3
If(OBJECT_ID('tempdb..#DETAIL') Is Not Null)Begin Drop Table #DETAILEnd CREATE TABLE #DETAIL ( ...
August 7, 2022 at 4:25 pm
Thank you for your interest.The result of the query will be as follows. I want to close the debt.
TrxnID MarkedAmount MarkedTrxnID1 ...
March 15, 2019 at 9:16 am
I am working on a complex problem - Bill Marking for Ageing Analysis. The data is like this :
Source Table :
TrxnID, Date, CustomerID, DebitCredit, Amount
March 15, 2019 at 1:26 am
Sorry.I made a late return :crying:Thank you really for your attention. 😉
Is there another way to secure the query ? I understand Clr...
January 10, 2019 at 9:31 am
Thank you so much.
I'm still not understanding how you read the ASSEMBLY code
January 7, 2019 at 12:25 pm
Thank you Jeff, Solomon
Are there other solutions for query encryption?
January 7, 2019 at 11:49 am
Thank you Jeff
Is there an application that translates the following code
CREATE ASSEMBLY [Database8] AUTHORIZATION [dbo] FROM 0x4D5A9000030000000400
January 6, 2019 at 12:38 pm
Thank you for your attention.
I want to translate query security to sqlclr.
I need this c # clr version of this query
January 6, 2019 at 12:16 pm
how to translate t-sql into clr
January 5, 2019 at 9:58 pm
Ingilizce bilmiyorum daha önceden belirttim. Kendi dilimde size yazacagim yardimci olursan memnun kalirim.
April 18, 2018 at 12:53 pm
The code below generally gives what I want, but I want the details. That is, when the output is the information of the relevant record
April 11, 2018 at 12:45 pm
Thank you very much for your interest.Because I do not speak English, I use translation.
There is a table where one entry is listed @IN
April 10, 2018 at 11:42 am
Last In First Out
I want to create a list according to.
April 10, 2018 at 7:49 am
Thank You 🙂
The common area of ??the table is as follows.
SELECT * FROM @IN F LEFT JOIN @OUTE G ON F.STOCK=...
April 9, 2018 at 3:11 pm