Sorry for the confusion everyone...Vasc, your last post is the way I wanted it. I apologize.

Thank you everyone. I believe this is going to work for me.

Much appreciated.

Regards

Bob

here is what i have so far:

select p.name,

sum(nSpeed), -- just do not sum up the nSpeed for those records with nStatus = 1

sum(nLineTotal)

from statusTable st join product p ON

st.pdtno...

No....nStatus values are as follows:

is if it is active nStatus = 3

if it is in maintenance nStatus = 1

So i do not want to include the nStatus = 1 in...

true....thanks.

have a great day!

Regards

Bob

excellent!!!! thank you soooo much Vasc....much appreciated!!!!

one last thing....sorry to be a pain in the neck...is there a way to format the hours so it shows in hh so 5...

Thanks Vasc...

The problem is I do not have a date, just a current speed and a remaining parts. Maybe I am doing a terrible job at explaining the situation. Let...

thank you Shaunio for the help....works like a charm.

i want to make it easy for my friend to just run the script file and not have to worry about importing a flat file.

David:

The whole purpose of this is to take the contents of 4 tables off of a server and drop their contents into an identical table at home for testing. The...