Třídová akce

Popis:

Vyhledá skladové karty a odběratele pro zadaný odběratelský název.

Kód:

18

Tělo:

SELECT 
  SC.ID, SC.Name, SC.Code,
  CASE WHEN (not F.Firm_ID is null) THEN
    F.Firm_ID
  ELSE
    F.ID
  END AS Firm_ID

FROM Subscribers SS
JOIN StoreCards SC ON SC.ID = SS.StoreCard_ID
JOIN Firms F ON SS.Firm_ID = F.ID
WHERE 
  (
    (Upper(SS.ExternalNumber COLLATE PXW_CSY) = Upper(CAST(:Text AS VARCHAR(100))))
    OR 
    (Upper(SS.Name COLLATE PXW_CSY) = Upper(CAST(:Text AS VARCHAR(100))))
  )
GROUP BY
  SC.ID, SC.Name, SC.Code,
  CASE WHEN (not F.Firm_ID is null) THEN
    F.Firm_ID
  ELSE
    F.ID
  END

ORDER BY
  -- Poradi preferuje presnou shodu hledaneho textu (case sensitive)
  MIN(
      CASE
        WHEN
          ((SS.ExternalNumber COLLATE PXW_CSY = CAST(:Text AS VARCHAR(100)))
          OR 
          (SS.Name COLLATE PXW_CSY = CAST(:Text AS VARCHAR(100))))
        THEN 1
        ELSE 2
      END
  )
 

Generated by ABRA Software a.s. 27.10.2021 16:34:11