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 gkittelson 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: *

  1. 512512512

    I need help coding a query in SQL? (filtering data)

    This is what I came up with but it seems broken Select Firstname+' '+Lastname As [Firstname Lastname] ,x.synctime As [Nestle Synctime] ,Sum(Durationinminutes) As [Duration In Minutes] From Tpeople p Join Tsynclog sl On sl.People_Id = p.Id join ( select people_id, max(synctime) as synctime from...
  2. 512512512

    I need help coding a query in SQL? (filtering data)

    Thats perfect! Thanks for your help
  3. 512512512

    I need help coding a query in SQL? (filtering data)

    I have a big presentation tomorrow and I have a query I'm trying to make a little more presentable. (filtering data) Tables: --tpeople --tsynclog The query: select Firstname+' '+Lastname as [FirstName LastName],synctime as [Nestle synctime],sum(DurationInMinutes) from tpeople join tsynclog...

Part and Inventory Search

Back
Top