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!
Recent content by Huslayer
-
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
Tsuji, Thank you so much for your help, you're the best..I ended up doing that ---------------------------------- Const ForReading = 1 Const ForWriting = 2 Const UniCode = -1 strSourceTxtFile = "PXDRAD January 2010 thru May 2010.txt" strTargetTxtFile = "PXDRAD January 2010 thru May 2010 - One... -
Merging 2 lines in one line, TEXT FILE
ohh no "[0.2] Since it appears in line #10, and that you read pass 20 lines ignoring them, there is no vbFormFeed character to split from line #21 to line #23." Sorry my code reads the whole data file not the sample, i test against the whole data file Ignore that skip on the sample file when... -
Merging 2 lines in one line, TEXT FILE
tsuji, good morning... Thanks for joining and god bless for sharing the knowledge :) but really I don't understand what you're talking about, i'm a DBA and just need to clean the data files before processing can you clarify please? code? example? Thanks -
Merging 2 lines in one line, TEXT FILE
Hey PHV, merci beaucoup for your help, i've tested it on the original file, but WOW it's still running for the last 30 minutes ! so i've gave it a try on the sample data file, it didn't work, it only have one line in the output. here's the script that i've used... -
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
MDXer, I figured it out using this query...... SELECT A.MedRecNo, A.AdmitDate, B.AdmitDate AS ReAdmitDate, A.DateOfDischarge, B.DateOfDischarge AS ReDateOfDischarge, A.PatientNo, B.PatientNo AS RePatientNumber, A.PatientName...- Huslayer
- Post #6
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Compare date fields in SQL server
Cheers for reply, you're too technical for me, I just don't know what to do with the results of the query... i'm not really a programmer, I know some basics and I work with SSIS. but really i'm stuck and need to get this report done, and I don't know what to do !! I've been search all over for...- Huslayer
- Post #5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Compare date fields in SQL server
Thank you MDXer for the fast reply... I've edited the query to look like this ---------------------------- WITH t AS( Select PatientName, medRecNo, AdmitDate ,DateOfDischarge , row_number() OVER(PARTITION BY PatientName Order by PatientName) as rec From report ) Select PatientName medRecNo ...- Huslayer
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
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
Lol, that was easy ....for you I mean... Thanks again, it worked wonderfully for me... i'll start reading more about VBScripting -
Remove quotation from a txt file using an automated script
PH, you're the best, thanks a zillion. my only concern that i don't understand the difference or your addition...can you explain it please when you have a chance... the reason i'm asking is I've a different report that comes in 5 lines this time!!! i'll post example for the file... -
Remove quotation from a txt file using an automated script
I've went this far -------------------- Const ForReading = 1 Const ForWriting = 2 Const TriStateUseDefault = -2 strInput = "c:\example.txt" strOutput = "c:\" & ShortDateTime(Now) & ".txt" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objInput =... -
Remove quotation from a txt file using an automated script
PH, Thank you so much for your propmet replay, whoever i'm not into programming, i'm in management and trying to automate the procedure that i'm doing. I started by reading online how to checkfor the source file and create the output file with the current date and time, but no luck so far -
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...
