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 Wanet Telecoms Ltd 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: MickDub
  • Content: Threads
  • Order by date
  1. MickDub

    Select First & Last

    HI all Quick one I pulling details from tabel and one the parts is to select the first time and last time in a day that a user writes to the tabel Example ID Time User Ext 1 08:00 1 A 2 08:30 1 A 3 08:45 1 A 4 09:00 1 A 5 10:00...
  2. MickDub

    DatePart Function

    i am using the DatePart function to do the following "Sum(CASE DATEPART(dw,pdate) When 1 Then 1 ELSE 0 END) AS Sunday" But would liek break sunday into morning and evening have tried (Ftiem been the tiem field on my table) "Sum(CASE DATEPART(dw,pdate) When 1 And Ftime between '01:00:00' And...
  3. MickDub

    Send Selected Data from sql server 2005 to excel

    Hi, All Wondering if someone one could help me on how to after i have written my select statement how do i send the records returned to excel So if i have "select f_Name,L_Name from table where L_name="Murphy" from Details", what do i need to do next to export the result to excel Cheers, Mick
  4. MickDub

    Query Help

    I have follwoing table showing part number M1 with 5 entries PONum PartNum 5331 M1 5331 M1 5332 M1 5332 M1 5332 M1 what i need help with is to be able to write a query that return that there are 5 entries for M1 and that its on two seperate PoNum's Part Num...
  5. MickDub

    Query Help

    i have follwoing table showing part number M1 with 5 entries PONum PartNum 5331 M1 5331 M1 5332 M1 5332 M1 5332 M1 what i need help with is to be able to qrite a query that return that even though there are 5 entries for M1 that it is only on two seperate...

Part and Inventory Search

Back
Top