Thanks for the reminder. Was guilty last time and you reminded me then. Just can't seem to get myself to use my live code/data. Must be a...

Thanks a bunch. Works like a charm.

Since I didn't give you the actual names in previous postings, here is what your suggestion looks like modified to fit the actual names:

select

A.empnum,

A.ename,

A.lname,

...

Close but no cigar.

For every ptran record I want to add all the hour fields together. Then sum that value for all the records in the table.

So if the...

thanks. did the trick.

Now I need to learn t-sql.

ok, per the link here is data from database2.ship:

SELECT ' 66359','1','FV-WI0090', UNION ALL

SELECT ' 67109','1','FV-S2030V', UNION ALL

SELECT ' ...

Thanks for the pointer. I will try to do it better.

First of all, the only code I tried was to select the records. If figured the first step...

Sorry, should have been clear. Both db's are on the same server.

Database1.customer has 1 field called kit. It is text. Database2.ship has multiple fields but one...

The install is from images downloaded from Microsoft. You don't get a CD anymore, just a login to Microsoft where you download the software.

I'll try re-downloading the software.

I have tried that with the same outcome. I even wiped and re-installed XP Pro.

Is it possible that it is something between XP Sp3 and Sql Server ?

Thanks for the education, I really appreciate it.

Don't see where Gallaxy Express gave me any tools for changing the sql server settings.

I don't see any management tools for sql server...