Thanks very much. I will try it that way. I am used to using bcp. I just could not think of the xp_cmdshell SP. I used to do this alot...

Thanks Andy

I am not sure how to write that is my problem. I will more than likely use the sysdatabases table to get a list of databases that I want...

Thank you so very much. That was a Great help.

Andrew

How long a minute is....

Depends on what side of the bathroom door you are on.

Thank You for your reply. I am wanting to use this on a SQL 2000 DB, with an ASP front end. I greatly appreciate your suggestions and advice.

I am just...

Sorry David

This did not work for me. It is not seperating the data accordingly. Thanks for the effort.

Andrew

How long a minute is....

Depends on what side of the bathroom door you...

Thank You everyone, I will try your suggestions and let you know. I would have choosen the decimal, but the calculations need to be very precise, but showing the results...

I am using SQL 2000.

🙂

I am sorry but this is not working.

I need to be able to update data that is in "Client" database with data that is in "Employee" database. I have tried...

Thanks for your reply

I am not sure what the '!' is about in the last command that you suggested in your posting to my question. C1.StartDate != Employees.StartDate Please clearify...

Thank You very much. It is working very well. I had to massage the code just a little, but it is calculating perfectly.

Thanks Again for all your assistance

Andrew 🙂

Thank You for your response and assistance. However, this is not working correctly I am afraid. I need this to permanently update the "TotalScore" Column for each record. There is...

I have 4 different columns that contain only tinyint, 1,2,3 or 4. This is what I need this to be able to do, not replace the current numbers in the...