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 TouchToneTommy 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: johncnoland
- Content: Threads
- Order by date
-
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...- johncnoland
- Thread
- Replies: 2
- Forum: Embarcadero: Delphi
-
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.- johncnoland
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
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...- johncnoland
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
