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

    using case to select duplicate named fields from joined tables

    I have two tables that I'm joining using left outer joins that have duplicate fields, but I only want to output these fields in one output field. example; select c.field_name, name_out = case when a.name is not null then a.name when b.name is not null then b.name end from table_name...
  2. tmartin99

    multiple on clauses on outer join

    I have a problem, I need to be able to pull fields from a table and can have 2 possible id's that can refer to the same id field in the table but come from 2 different tables. I need to be able to do syntax like the following: LEFT OUTER JOIN chrisprd.TASSIGNMENT A on...
  3. tmartin99

    importing text file into new SQL server table

    I am importing a 13 field text file into SQL Server using DTS and the first column is a 9 digit text field and the last field is a 9 digit text field. The first field will always have data, but the last field can contain "null" values, but when I import the file, if the last field is...
  4. tmartin99

    view generation script execution time

    I have a view that I am building that uses left outer joins to combine multiple views and tables. Up to a point of adding addition (needed) views and tables to this join it will execute in about 1:40 sec, and returns about 850 rows, but if I add just one more table/view then the execution time...
  5. tmartin99

    how to use a select statement to return the first 250,000 records

    Does anyone know how to use just a select statement to 1. return the first 250,000 records from a table, then 2. return the next 250,000 records from a table. on subsequent runs of the sql script?
  6. tmartin99

    how to convert date field to format mmddyyyy

    I have a date field in a SQL 2000 table that I need to output in the format mmddyyyy and can't seem to find a function to do it?

Part and Inventory Search

Back
Top