mattiaswolff

UPDATE e
SET e.reservedby = NULL
FROM ERRAND e
INNER JOIN ERRAND_HISTORY eh ON (e.ID = eh.ERRANDID
                                 AND eh.Tag = 'ERRAND_RESERVED')
WHERE e.RESERVEDBY IS NOT NULL
    AND eh.MODIFIEDDATE < DATEADD(MINUTE, -60, GETDATE())
    AND eh.ID =
        (SELECT top 1 ID
         FROM ERRAND_HISTORY

mattiaswolff

-- Update rowstate to posted
UPDATE NAV_IN_MESSAGE_TAB_TRANS
SET ROWSTATE = 'Posted'
WHERE message_id IN
        (SELECT message_id
         FROM nav_in_message_tab_trans nimtt
         INNER JOIN ERRAND e ON (e.ID = nimtt.ERRAND_ID)
         INNER JOIN INVOICE_HEAD ih ON (e.INVOICEID = ih.ID)
         WHERE ih.PaymentTransferred = 10
             AND e.VISIBLE = 0

mattiaswolff

UPDATE NAV_IN_MESSAGE_TAB_TRANS
SET ROWSTATE = 'Posted'
WHERE message_id IN
        (SELECT message_id
         FROM nav_in_message_tab_trans nimtt
         INNER JOIN ERRAND e ON (e.ID = nimtt.ERRAND_ID)
         INNER JOIN INVOICE_HEAD ih ON (e.INVOICEID = ih.ID)
         WHERE ih.PaymentTransferred = 6
             AND e.VISIBLE = 0
             AND nimtt.MESSAGE_ID IN

mattiaswolff

SET nocount ON DECLARE @intC integer DECLARE @intD integer DECLARE @intMax integer DECLARE @intMin integer DECLARE @strString nvarchar(1000) DECLARE @Databases TABLE (ID int, Name nvarchar(200))
INSERT INTO @Databases (ID, Name)
SELECT database_id,
       name
FROM sys.databases
WHERE name LIKE '[[DATABASE_NAME]]' -- REPLACE WITH DATABASE NAME ('%' can be used to use several databases)
    SET @intC = 0 While @intC <
        (SELECT MAX(ID)
         FROM @Databases) BEGIN
    SET @intC =

mattiaswolff

option batch abort
option confirm off
open [[USERNAME]]:[[PASSWORD]]@[[SERVER]]:[[PORT]]
get ./*.* "[[OUTPUT PATH]]"
rm ./*.*
exit

mattiaswolff

"[[PATH TO 7-ZIP]]\7z.exe" e "[[PATH TO ZIP-FILES]]" -o"[[PATH TO OUTPUT FILES]]" [[FILES TO UNZIP]]
"c:\Program Files\7-Zip\7z.exe" e "C:\MIG_Services\ReadsoftOnline Demo\STH1\Import\" -o"C:\MIG_Services\ReadsoftOnline Demo\STH1\Unzipped\" *.xml

mattiaswolff

--Please notice this script does not check if inserted values already exist. This needs to be done manually.
--Replace: [[ARCHIVE PATH]]
--Replace: [[ROLE]]
--Replace: [[PARTNER NAME]]
--Replace: [[PARTNER DESCRIPTION]]

UPDATE permission
SET ACTIVE = -1
WHERE TAG = 'DOWNLOAD_INVOICE_EDI_SOURCE'
    UPDATE permission

mattiaswolff

REN *.prc *.sql

mattiaswolff

declare @strAccount nvarchar(20)
declare @strCompanyId nvarchar(20)
set @strAccount = ''
set @strCompanyId = ''


SELECT InvoiceNumber,
       VerificationIdentity,
       SupplierName,
       ps.SupplierId,

mattiaswolff

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '[[Text to search for]]'
GROUP BY OBJECT_NAME(id)
ORDER BY OBJECT_NAME(id)