nikolasd

SELECT
  hedocseries.hecode DocCode,
  hedocseries.heshortcut DocShortcut,
  hedocseries.hename DocName,
  hedocseries.heactive DocActive,
  payment.hecode PayCode,
  payment.heshortcut PayShortcut,
  payment.hename PayName,
  payment.heactive payActive
FROM hedocseries

nikolasd

-- Εμφάνιση βαθμών στο Λ.Σ. για Γ' Κατηγορίας
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,

nikolasd

SELECT
    OBJECT_NAME(f.parent_object_id) TableName,
    COL_NAME(fc.parent_object_id, fc.parent_column_id) ColName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
    ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.tables t
    ON t.OBJECT_ID = fc.referenced_object_id
WHERE COL_NAME(fc.parent_object_id, fc.parent_column_id) = 'HEPRLSID'
ORDER BY OBJECT_NAME(f.parent_object_id)

nikolasd

SELECT
    heresnum,
    COUNT(*)
FROM HERESERVATIONS
GROUP BY heresnum
HAVING COUNT(*) > 1

nikolasd

/*
Επιστρέφει τον κάτοχο, το αξιόγραφο, το παραστατικό πληρωμής
με το οποίο εκδόθηκε το αξιόγραφο και τον συναλλασόμενο
που αφορά το αξιόγραφο
*/

SELECT
  heBanknoteTrans.HEOWNERNAME,
  heBanknotes.HECODE AS BankNote,
  heBanknotes.HEBANKNOTENUM,

nikolasd

function main() {
   	var arrivalDate = sc$Row.Item["heArrival"].ToString();
   	var departureDate = sc$Row.Item["heDeparture"].ToString();
   	var roomNumber = sc$Row.Item["RoomCode"];
   	var strSQL = "SELECT HEMEALPLANS.HECODE AS MEAL FROM HERESERVATIONS INNER JOIN HEMEALPLANS ON HEMEALPLANS.HEID = HERESERVATIONS.HEMLPLNID INNER JOIN HEHOTELROOMS ON HEHOTELROOMS.HEID = HERESERVATIONS.HERMID WHERE HERESERVATIONS.HEARRIVAL = '" + arrivalDate +"' AND HERESERVATIONS.HEDEPARTURE = '" + departureDate +"' AND HEHOTELROOMS.HECODE = '" + roomNumber + "'";
   	var mealPlan = sc$Db.ExecuteScalar(strSQL);
   	return mealPlan;
}

function main() {

nikolasd

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

nikolasd

SELECT
    *
FROM HECUSTOMERS
INNER JOIN HEHOTELCUSTOMERS
    ON HEHOTELCUSTOMERS.HECSTMID = HECUSTOMERS.HEID
WHERE HEHOTELCUSTOMERS.HECUSTTYPE = '1'

nikolasd

SELECT
    POVALSTR
FROM POSYS
WHERE POKEY = 'Application Version'

nikolasd

SELECT
    DOCENTRIES.HEID,
    DOCENTRIES.HEENTRYDATE,
    DOCENTRIES.HEOFFICIALDATE,
    DOCENTRIES.HEDOCCODE,
    DOCENTRIES.HESTATUS,
    DOCENTRIES.HEDOCNUM,
    DOCENTRIES.HESOURCETYPE,
    DOCENTRIES.HEDCSRID,
    DOCENTRIES.HEDCSRTYPE,