home *** CD-ROM | disk | FTP | other *** search
/ PC World 2003 December / PCWorld_2003-12_cd.bin / Software / komercni / alc / ep2sr51csy.msi / Ep.CAB / q12 < prev    next >
Text File  |  2003-08-04  |  401b  |  8 lines
  1. parameters [Od data] T_DATETIME, [Do data] T_DATETIME
  2. select as "P°esuny HIM podle data"=s "Druh"=druh, "objekt"=@object, "HIM"=[Inventßrnφ Φφslo] where [Inventßrnφ Φφslo]
  3. with
  4.  select history as s1 "provedl"=@user,"popis"=@description
  5.   where @date>=[Od data] and @date<=[Do data] and (@flags=H_TO or @flags=H_TONEW or @flags=H_SCANTO or @flags=H_SCANTONEW)
  6. having s1
  7. endwith
  8. group by s1.@date