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!

  • Congratulations Chriss Miller 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: pwilson
  • Content: Threads
  • Order by date
  1. pwilson

    Join With Min(date)

    Employees Id Name 1 Joe 2 Carol 3 Susan DateLog ID date Employee Note 1 10-1 1 Fun 2 10-1 1 Great 3 10-10 3 monkeys rule 3 12-12 3 i like elephants So I want All employees with their earliest date applied, but also the...
  2. pwilson

    Time is unsynchrnoized

    We have a 2003 server that is having the daily problem of the time becoming unsynchronized. It seems to be off 2-3 minutes everyday. I changed the wendows time synch to update daily, but that seems to be a bandaid to the problem. It startet out being off a couple minutes a week. I dont want...
  3. pwilson

    Execution Plan Question

    Looking at the estimated execution plan for these they look the same, i think. Are there any differences? Select * from Table1 T1 INNER JOIN Table2 T2 ON T1.ID=T2.T1ID WHERE T1.Field1=@var Select * from (SELECT * From Table1 WHERE Field1=@var) AS T1 INNER JOIN Table2 T2 ON T1.ID=T2.T1ID...
  4. pwilson

    DateDiff problem

    This problem comes from an access database and old asp code. The program is basically a punch clock. People punch in and out. This is the basic guts of a punch record The date and time are separate because it was originally put together in access and looked prettier then. It is now beind...
  5. pwilson

    Trying to Rewrite WHERE IN Query

    I am having serious slowness issues for something that should be speedy. Basically I want to find the highest point value(pv) for a referral(excluding pv's that are smaller for duplicate account numbers) So if the table looked like this ID AccntNum EmpID PointValue 1..3444.....45....60...
  6. pwilson

    Updating the dataBind to a Repeater/Datalist...

    I have a DropDownList and a Repeater which is based on the selection in that List. When the SelectedIndex is changed I need the Data in the Repeater to be updated. (It doesn't have to be a repeater, I used that because it was displaying the recordset) my aspx file is basically...

Part and Inventory Search

Back
Top