Viewing 15 posts - 181 through 195 (of 601 total)
1. A Foreach container is created
2. Grabs the full path of each file into a variable
3. Imports the file path variable into a temporary processing table
4. Imports the [first] and...
January 15, 2015 at 2:42 pm
I don't think Phil realized you'd need optimization help right away (or had that many files to process) when he said "feel free to post another thread'. Lol.
No reason this...
January 15, 2015 at 2:30 pm
The optimal thing we would need would be create table definitions for samples of the 8 tables,
insert commands to insert test data into them, and then a view of...
January 15, 2015 at 1:57 pm
cstg85 (1/15/2015)
Thanks for the quick response, here's the kicker the only possible common denominator is the product number that is tested.
I have no idea what you mean. Maybe you...
January 15, 2015 at 1:42 pm
basically you just need to group by those fields, with a count(1).
We can give you the code if you tell us what the multiple tables are and how they join...
January 15, 2015 at 1:34 pm
A bit confusing what you are going for here.
Is the table you are inserting into on one server only, with details from all the servers you loop through? Or are...
January 15, 2015 at 9:57 am
1) Did you try out my rewrite of the query?
2)
The sub-query joins the child table with the validation table and then after that joins to the parent table.
It...
January 14, 2015 at 12:59 pm
I would not have thought the slowness would be due to the derived table he used to enable your joins. I would think its more likely a question...
January 14, 2015 at 12:14 pm
So, have you actually solved your problem yet with Chris' solution, or is there still an issue with what you are trying to do?
January 14, 2015 at 10:41 am
sqlquery29 (1/14/2015)
We have a SSIS package that is taking around 10 hrs loading around 43 million records which is taking around 14 GB data.
This package has around 30 Sql...
January 14, 2015 at 7:23 am
dwain.c (1/7/2015)
My solution can look for any list of patterns:
Right, but you need the list.
I was more asking if he needed the code to identify patterns then look for them,...
January 8, 2015 at 12:23 pm
aaron.reese (1/6/2015)
Unfortunately that is the simplified version 😀
Let's concentrate on the first part: finding records with the same repeating patterns but in different time phases.
A manual scan of the data...
January 7, 2015 at 10:12 am
Are there any constraints at all on how many changes can be considered a pattern, or to help identify the start/end of a new pattern iteration?
Failing that (or maybe even...
January 6, 2015 at 1:33 pm
Well, the maximum error count is on the package, not on the stored procedure. It doesn't know the stored proc has hit an error until the proc returns. ...
January 5, 2015 at 11:13 am
Viewing 15 posts - 181 through 195 (of 601 total)