Because of this statement:

What I need is actual labor per product per batch receipted per warehouse.

I will probably have to do some math. Then I'll do a GROUP BY.

thanks

I tried adding a DISTINCT according to what I read in BOL, but I guess I don't get it either. It's in the second field in the first line below:

SELECT...

What I need is actual labor per product per batch receipted per warehouse.

I tried GROUP BY, but it tells me to basically put every field in the...

will give it a shot.

thanks

Both of you: thanks.

Markus: do you know of any tutorials to do what you describe?

gotcha. thanks

thanks. What's the advantage of having more than one .trn file?

When I see the word "upgrade" I think of it as upgrading an existing computer. In this case, we are moving everything from an old server, running on Windows 2000...

It appears they didn't realize what the master DB does. I think I have them convinced that it doesn't need to move.

Ok, that little section at the top with the calendar is probably the culprit. I say this because the two which are working both have something there, called a sub-plan,...

So if I back up the lgos regularly, it will make the logs smaller?

Ok, I have no idea how to do that, but will research. thanks.

I am doing a full backup now, using the GUI (SSMS).

Well, I had to do it different than directed. I hope I didn't screw anything up. I removed the command to backup the database.

USE CHEMPAXDW

GO

BACKUP LOG [CHEMPAXDW] WITH TRUNCATE_ONLY

DBCC...

Thanks. I do intend to limit the growth in the future, and I appreciate the instructions.

First things first, though. I will try to do the truncate thing now. Let's...