Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: immad
  • Order by date
  1. immad

    OFF DAYS

    sir i want to show off days in my report my sql data is like this date----------timein------timeout--shift----------eid 2-May-2013--9:20AM---6:17PM-----G-----------17090 3-May-2013--9:09AM---2:01PM-----G-----------17090 4-May-2013--9:03AM---10:41AM----G-----------17090 sql data does...
  2. immad

    calculate excess short and show in one column

    this is my data -------------------------row 1--------------------------row 2 date-------------2013-01-04 00:00:00.000-------2013-01-04 00:00:00.000 eid--------------26446-----------------------------26446 timein-----------2013-06-11 09:44:00.000-----2013-06-11 13:56:00.000...
  3. immad

    data

    sir this query give me first time in and last time out result SELECT a.eid, a.date, d.InTime, e.OutTime FROM (SELECT DISTINCT eid, date FROM atend) a OUTER APPLY (SELECT b.eid, b.Date, MIN(b.Time) InTime FROM atend b WHERE a.eid = b.eid AND a.date = b.date GROUP BY b.eid, b.Date) d OUTER APPLY...
  4. immad

    call a procedure

    i have a procedure name query i want to make a procedure name proc and call this query procedure inside this procedure
  5. immad

    Query Problem

    Thanks its working
  6. immad

    Query Problem

    Dear imex query give me this result eid--------------date--------------------timein-----------------------------timeout 886------2013-01-01 00:00:00.000---2013-06-10 08:07:00.000---2013-06-10 20:09:00.000 but actual data is this...
  7. immad

    Query Problem

    my data is like this eid-----------date------------------------------time--------------------------status 26359---2013-01-01 13:00:00.000------2013-01-01 09:50:00.000--------IN 26359---2013-01-01 13:00:00.000------2013-01-01 11:47:00.000--------OUT 26359---2013-01-01...

Part and Inventory Search

Back
Top