Last active
October 23, 2018 13:37
-
-
Save nikolasd/cc4a97a916f4d8c88eae27191efd47db to your computer and use it in GitHub Desktop.
Pylon SQL - Εμφάνιση βαθμού Λ.Σ.
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 | |
CASE | |
WHEN PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 3) IS NULL THEN 0 | |
ELSE LEN(PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 3)) | |
END, | |
CASE | |
WHEN PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 4) IS NULL THEN 0 | |
ELSE LEN(PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 4)) | |
END, | |
CASE | |
WHEN PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 1) IS NULL THEN 0 | |
ELSE LEN(PARSENAME(REPLACE(heCompanies.HEGENACCMASK, '-', '.'), 1)) | |
END | |
FROM HECOMPANIES | |
-- Εμφάνιση βαθμών στο Λ.Σ. για Έσοδα - Έξοδα | |
SELECT | |
CASE | |
WHEN PARSENAME(REPLACE(heCompanies.HEREVEXPMASK, '-', '.'), 2) IS NULL THEN 0 | |
ELSE LEN(PARSENAME(REPLACE(heCompanies.HEREVEXPMASK, '-', '.'), 2)) | |
END, | |
CASE | |
WHEN PARSENAME(REPLACE(heCompanies.HEREVEXPMASK, '-', '.'), 1) IS NULL THEN 0 | |
ELSE LEN(PARSENAME(REPLACE(heCompanies.HEREVEXPMASK, '-', '.'), 1)) | |
END | |
FROM HECOMPANIES |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment