Posts by Giovane Barbosa • 33 points
5 posts
-
0
votes1
answer223
viewsA: How do I create an alert through a Trigger by not blocking the Insert?
The correct function that I should use is the PRINT('RETURN MESSAGE') function. This would work, SQL returns the message and proceeds with the function. But in the system that I work, the system has…
-
1
votes1
answer223
viewsQ: How do I create an alert through a Trigger by not blocking the Insert?
Guys, usually whenever I create a Rigger is to perform insertion blocking or only update values. But this time I just need the system to alert not stopping the person performing the document…
-
0
votes2
answers314
viewsQ: Return last entry of each product
help me. I’m in a situation where I want to bring only the last note entry of each product to create a report. I created a select, but there are products repeating where they shouldn’t. See select:…
-
0
votes3
answers694
viewsA: how do I make a row_number keeping the document number with different plots?
my select: SELECT RC2_DOCREC, ROW_NUMBER () OVER (PARTITION BY R2.RC2_DOCREC ORDER BY R2.RC2_DOCREC) NUMDOCUMENTO, RC1_CLIENTE , RC2_PARCELA --INTO MIG_DOCREC FROM MIG_CARAJAS.. RECEBER1 R1 INNER…
-
1
votes3
answers694
viewsQ: how do I make a row_number keeping the document number with different plots?
I would like to know how to create a row_number keeping the numbers of documents equal creating the sequence by parcel. example: doc / cliente / parcela 10 15 1 10 15 2 10 15 3 23 59 1 23 59 2 23 59…