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 Mike Lewis 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: *

  1. johncnoland

    translation

    I have done a lot of work localizing an application. After reviewing the options, we settled on a product called Multilizer. It is a bit pricey, but will save you a ton of time. Are there any forms or messages that need to be localized?
  2. johncnoland

    Delphi ADO and writing an .xls

    It is helpful, but my concern in using the server objects is that they would suffer from the same 254 character string limit I am experiencing when I import a tab delimited file. My input file is an inventory list with long and short descriptions. The long descriptions are formated HTML code...
  3. johncnoland

    Delphi ADO and writing an .xls

    I just saw a thread from last Oct that mentioned you can read and write to .xls files using ADO. I am currently importing tab delimited files into Excel (03 & 07). The problem I have is Excel truncates text column data at 255 characters. When working in Excel you can add more than 255...
  4. johncnoland

    Retrieving records from table A that are not in Table B

    Table A is a master set of keys values (Date, ID, City). The records in Table B represent a sub-set of the key values in Table A. How can I retrieve the records in Table A that are not in Table B? Thought of using a sub-query but don't those only return a single column? Using SQL 2000.
  5. johncnoland

    Combine 2 result sets & SUM with GROUP BY without a TempTable

    Thanks for your response. I have been away from SQL Server for over 6 years (version 6.5!) so I have a lot of catching up to do. I have been doing a lot of ready here!
  6. johncnoland

    Combine 2 result sets & SUM with GROUP BY without a TempTable

    I am generating records to back fill an Excel Pivot Report. Three key columns on the left with numerous data columns across the top. When I pull a SQL result set, not all keys are accounted for, so I have some cells with data and some with blanks. I can automatically zero fill the missing...

Part and Inventory Search

Back
Top