I may be missing something but when I run the query it doesn't display the number of tests. What am I doing wrong?

Nevyn,

To answer your questions

1) Each product number can be tested by each one of the tests.

2) I need the data sorted by date, then grouped by serial number...

Sorry about that.

So each table is a type of test, (as you can see from my sloppy code below.) In those tables we store the date/time, serial number, test type...

Thanks for the quick response, here's the kicker the only possible common denominator is the product number that is tested.

WendellB,

The code snippet in your previous email worked, thanks again for all your help, time and patience!

Wendell, thank you for your patience with me!

Here is some sample data, right now I have data in two columns in a table. The first column is a date...

WendellB,

Thank you for the quick response, I attempted to use the query you provided and in the average column it puts the date. So my goal is to have a...

Thank you very much for the reply, I tried to get the for each loop but was unsuccessful. However I failed to tell you that each file has its own...

Eirikur, thank you for the response. At first it wouldn't pull in the time with the date, that was actually caused by the flat file souce, it was set to...

Would it be possible to create an SSIS package that would...

1)Run a sql query to drop all the tables

2)Create the new tables using an Execute T-SQL Statement ??

example:...