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 Rhinorhino 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: mattjp
  • Content: Threads
  • Order by date
  1. mattjp

    Win XP License Key

    Hey, I just did a clean install of XP on an old dell d630 laptop from the system restore disks that came with it. Problem is, I can't find the original XP license key--the one printed on the bottom of the laptop is for vista. I have access to a site license key through my university, but the...
  2. mattjp

    ODBC in a Shared Excel Workbook

    Hello, I am trying to setup an ODBC connection to MS SQL Server from an Excel 2003 workbook. Whenever the workbook is in non-shared, single-user mode, the connection works fine and the linked data can be refreshed, etc.; but when shared mode is activated the data becomes static and the...
  3. mattjp

    Data combination

    Hello, I am trying to create a view that sums data from two tables in this fashion: Table 1: A 3 B 5 C 1 Table 2: A 1 C 1 D 3 To produce: A 4 B 5 C 1 D 3 What is the best way to do this? I have tried using unions, outer joins, but I can't seem to get it to work--I keep running...
  4. mattjp

    Simple Grouping Query Question

    Hi, I'm relatively green at SQL queries, and I was wondering what the best way to construct a t-sql query on this data: table: activitylog fields: serial#, starttime, stoptime, activity 'serial' is non-unique, 'serial' + 'starttime' is unique. I need a query that will return, for each serial...
  5. mattjp

    Simple SQL grouping question

    Hi, I'm relatively green at SQL queries, and I was wondering what the best way to construct a t-sql query on this data: table: activitylog fields: serial#, starttime, stoptime, activity 'serial' is non-unique, 'serial' + 'starttime' is unique. I need a query that will return, for each serial...

Part and Inventory Search

Back
Top