Comments (...)

SQL - Geolokace v číselníku partnerů

 

SELECT

 

   p11.Cislo AS CisloPartnera,

   p11.Cislo32 AS IdentifikaceRozvozu,

   p11.Cislo32D AS NazevPartnera,

   p11.Poznamka,

 

   p11.Double_03 AS Lat,   // GEO - realne Lat

   p11.Double_04 AS Lon,   // GEO - realne Lon

 

   p11.Int_01,   // GEO - stupen Lat

   p11.Int_02,   // GEO - minuta Lat

   p11.Double_01,   // GEO - sekunda Lat

   p11.Int_05,   // GEO - Lat NS

 

   p11.Int_03,   // GEO - stupen Lon

   p11.Int_04,   // GEO - minuta Lon

   p11.Double_02,   // GEO - sekunda Lon

   p11.Int_06,   // GEO - Lon EW

 

   p11.String_64_01 AS OtevrenoPo,   // Oteviraci doba Po

   p11.String_64_02 AS OtevrenoUt,   // Oteviraci doba Ut

   p11.String_64_03 AS OtevrenoSt,   // Oteviraci doba St

   p11.String_64_04 AS OtevrenoCt,   // Oteviraci doba Ct

   p11.String_64_05 AS OtevrenoPa,   // Oteviraci doba Pa

   p11.String_64_06 AS OtevrenoSo,   // Oteviraci doba So

   p11.String_64_07 AS OtevrenoNe,   // Oteviraci doba No

 

   p11.String_64_08 AS DodaniPo,   // Doba dodavky Po

   p11.String_64_09 AS DodaniUt,   // Doba dodavky Ut

   p11.String_64_10 AS DodaniSt,   // Doba dodavky St

   p11.String_64_11 AS DodaniCt,   // Doba dodavky Ct

   p11.String_64_12 AS DodaniPa,   // Doba dodavky Pa

   p11.String_64_13 AS DodaniSo,   // Doba dodavky So

   p11.String_64_14 AS DodaniNe,   // Doba dodavky Ne

 

   p11.String_64_15 AS Poznamka1,   // Poznamka 1

   p11.String_64_16 AS Poznamka2,   // Poznamka 2

   p11.String_64_17 AS Poznamka3,   // Poznamka 3

   p11.String_64_18 AS Poznamka4,   // Poznamka 4

   p11.String_64_19 AS Poznamka5,   // Poznamka 5

   p11.String_64_20 AS Poznamka6,   // Poznamka 6

   p11.String_64_21 AS Poznamka7,   // Poznamka 7

 

   p11.ZmenaDatum,

   p11.ZmenaDatumServer,

   p11.ZmenaKdo,

   p11.ZmenaPC,

 

   p.ICO AS ICO   // priklad parametru z ciselniku partneru

 

FROM

   HR__P211 p11, HR__P200 p

WHERE

   (p.Cislo=p11.Cislo)

 

Comments (...)