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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Join to join 2 select statments
Hello all, sorry for my query, it's a long one basically it consists of 2 select statements on 2 tables, each select statement gets the top 10 and self join it to the rest 90 as others. now I need to join the 2 statements together full join, as there's of course different top 10s in each of...- Huslayer
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Merging 2 lines in one line, TEXT FILE
Hello VBS Gurus, I've an easy challenge for you :) I'm working on a text file, the Data comes in 2 lines, but some lines has "FORM FEEDER", doing the following code to replace the form feeder by a new line and then split the contents so I can merge the 2 lines the results: It removes and... -
Compare date fields in SQL server
Hi all, I've a flat file that I cleaned the data out using SSIS, the output looks like that : MEDICAL ADMIT PATIENT PATIENT DATE OF DX REC NO DATE NUMBER NAME DISCHARGE Code DRG # 123613 02/16/09...- Huslayer
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Remove quotation from a txt file using an automated script
Hello, I need some help creating a batch file to automate the process of removeing double quotes in a text file. the double quotes are in the beggining of the file and at the end of the file. also in the middle and removes 2 spaces to join two lines into one line. example is attached in the...
