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!

Recent content by tmartin99

  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

    OK thanks, also I'm having a mind cramp, if one of the tables on the right side that I'm joining has multiple rows per id and I just want to select one of them how can I do that?
  3. 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...
  4. 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...
  5. tmartin99

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

    Does SQL Server not have rowid's like Oracle? in Oracle you can say: select rowid from dual;
  6. 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...
  7. 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?
  8. tmartin99

    how to convert date field to format mmddyyyy

    thanks so much, I'm new to SQL Server, you can do the same function in Oracle using to_char(datefield,'mmddyyyy')
  9. 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?
See more

Part and Inventory Search

Back
Top