Třídová akce

Kód:

14

Tělo:

Select  distinct SC.ID, SC.Name, SC.Code, SU.ID as UnitID, SP.QUnit,
case when (not F.Firm_ID is null) then
  F.Firm_ID
else
  F.ID
end as Firm_ID,
(case when ((SP.ExternalNumber collate PXW_CSY = cast(:Text as varchar(100)))
      Or (SP.Name collate PXW_CSY = cast(:Text as varchar(100))))
   then 1
   else 2
end) mysortcolumn
from Suppliers SP
  join StoreCards SC on SC.ID = SP.StoreCard_ID
  left join StoreUnits SU on SU.Parent_ID = SC.ID and SU.Code = SP.QUnit
  left join Firms F on SP.Firm_ID = F.ID
where (Upper(SP.ExternalNumber collate PXW_CSY) like Upper(cast(:Text as varchar(100))) )
      Or (Upper(SP.Name collate PXW_CSY) like Upper(cast(:Text as varchar(100))))

order by mysortcolumn

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