This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
find /my/folder/subfolder/ -type f -exec du -Sh {} + | sort -rh | head -n 5 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE hecustomers | |
SET hecode = a.newcode | |
FROM (SELECT | |
heid, | |
concat(LEFT(hecode, 5), RIGHT(concat('00000000', ROW_NUMBER() OVER (ORDER BY hecode)), 8)) AS newcode | |
FROM hecustomers) AS a | |
INNER JOIN hecustomers | |
ON hecustomers.heid = a.heid | |
UPDATE hesuppliers |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
ser.heCode AS DOCSERIES, | |
ser.heShortcut AS DOCSERIESSHORTCUT, | |
ser.heName AS DOCSERIESNAME, | |
typ.heCode AS DOCTYPE, | |
typ.heName AS DOCTYPENAME, | |
acc.heCode AS ACCTMP, | |
acc.heName AS ACCTPMNAME, | |
cmp.heName AS CMP | |
FROM heDocSeries AS ser |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Update sequence current value with max reference number | |
-- example is for HEITEMS sequence | |
DECLARE @refno int = (SELECT | |
CAST(MAX(HEITEMS.herefnumber) AS int) | |
FROM HEITEMS) | |
DECLARE @inc int = (SELECT | |
CAST(current_value AS int) | |
FROM sys.sequences | |
WHERE name LIKE 'HEITEMS%') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Check DBs | |
/* | |
DECLARE @pylonVer varchar(20) -- current pylon ver | |
-- specify current pylon version | |
SET @pylonVer = '170432' | |
SELECT | |
name | |
FROM master.dbo.sysdatabases |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Convert String to DateTime with ParseExact | |
docEntry.SetValue("OfficialDate", DateTime.ParseExact(Convert.ToString(listDic[0]["OfficialDate"]), "yyyy-MM-dd hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture)) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
DOCENTRIES.HEID, | |
DOCENTRIES.HEENTRYDATE, | |
DOCENTRIES.HEOFFICIALDATE, | |
DOCENTRIES.HEDOCCODE, | |
DOCENTRIES.HESTATUS, | |
DOCENTRIES.HEDOCNUM, | |
DOCENTRIES.HESOURCETYPE, | |
DOCENTRIES.HEDCSRID, | |
DOCENTRIES.HEDCSRTYPE, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
POVALSTR | |
FROM POSYS | |
WHERE POKEY = 'Application Version' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
* | |
FROM HECUSTOMERS | |
INNER JOIN HEHOTELCUSTOMERS | |
ON HEHOTELCUSTOMERS.HECSTMID = HECUSTOMERS.HEID | |
WHERE HEHOTELCUSTOMERS.HECUSTTYPE = '1' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
ser.heCode AS DOCSERIES, | |
ser.heShortcut AS DOCSERIESSHORTCUT, | |
ser.heName AS DOCSERIESNAME, | |
typ.heCode AS DOCTYPE, | |
typ.heName AS DOCTYPENAME, | |
acc.heCode AS ACCTMP, | |
acc.heName AS ACCTPMNAME, | |
cmp.heName AS CMP | |
FROM heDocSeries AS ser |
NewerOlder