Viewing 6 posts - 31 through 37 (of 37 total)
We do exactly this for some major flat file data loads. The files are so wide it is pretty much impossible to work with in the SSIS user interface but...
July 25, 2014 at 6:21 am
Is there a way to download these examples, copying text out of those scrolling boxes is a pain and carries along formatting code.
November 29, 2012 at 5:31 am
The method with the table of dates runs four times faster. This based on repeated tests with 1.8 million rows in the source table and putting out 6.9 million rows...
October 23, 2012 at 8:55 am
Well, since you said "easy on the eyes" i reformatted this. I'll take a look at it next week.
DECLARE @T TABLE (
PatientID INT,
StartDate DATETIME,
EndDate...
October 20, 2012 at 4:55 am
Wow, Ray M. That looks very promising. Thanks!!!!
October 17, 2012 at 9:39 am
Yes, but I have to do some kind of loop to build those three records, one record for each day.
October 17, 2012 at 7:38 am
Viewing 6 posts - 31 through 37 (of 37 total)