Posts by AndyDaSilva52 • 11 points
4 posts
-
0
votes1
answer1617
viewsA: How to generate Nfe/NFC-e/CF-e/CT-e Key Checker Digit
Follows a code from a function that assists: CREATE FUNCTION F_CHAVE_DFe_GERAR_ChaveSemDV(@ChaveSemDV nvarchar(43)) RETURNS nvarchar(44) BEGIN DECLARE @Dv Nvarchar(1) --- PEGO O TAMANHO DO NÚMERO DE…
sql-serveranswered AndyDaSilva52 11 -
1
votes1
answer1617
viewsQ: How to generate Nfe/NFC-e/CF-e/CT-e Key Checker Digit
How to Calculate the Nfe Key Checker Digit? For example, which Key checker digit has 43 positions: '2411050954052500019455001000000709124205076'
sql-serverasked AndyDaSilva52 11 -
0
votes1
answer2819
viewsA: Oracle - How to generate every day (Calendar) between two Dates with different Years (*No Support Table)
The following code can be used: SELECT CAL.DATA ,TO_NUMBER(TO_CHAR(CAL.DATA,'DD')) AS Dia ,TO_NUMBER(TO_CHAR(CAL.DATA,'MM')) AS Mes ,TO_NUMBER(TO_CHAR(CAL.DATA,'YY')) AS "AnoYY"…
oracleanswered AndyDaSilva52 11 -
0
votes1
answer2819
viewsQ: Oracle - How to generate every day (Calendar) between two Dates with different Years (*No Support Table)
How to generate the interval of all days of the months between two dates? Considering only the parameters: Starting Date: 01/10/2014 End Date: 12/29/2018 Example: 01/01/2014 02/01/2014 03/01/2014…
oracleasked AndyDaSilva52 11