It's not the inner and outer joins I'm worried about. It's the cross joins!!

If there is such a group we need to make sure replication is turned off by...

I'm not sure why you want to use another package to populate the variables.

Most of the packages I build have as one of the first steps a task that initializes...

You can go ahead and use the DBCC commands to shrink the database files. I never heard of any issue regarding the 5 GB.

Keep in mind that shrinking database...

My eyes are getting old too.

The query has to produce the same results when it's reversed, so what else could it be?

Had the case been the same in both queries...

You have in the first query:

ON agrt778.prd = itdmn78.prodno

and in the second query:

ON itdmn78.PRDNO = agrt778.prd

notice PRDNO vs. prodno

Is that a typo in posting to this forum? Or is it...

Like someone already said, do not confuse database files with data files.

If you do not agree that the log file is a database file then go ahead and remove the...

Are you missing a BEGIN and and END? (See below)

This is what I am trying to do:

IF order EXISTS in the orders table

Begin

Insert that order into DuplicateOrders table

End

Else ...

This sounds like a job for SSIS to me. As someone said earlier, use SSIS to load the data in smaller batches.

That's what I would do.

RPSql,

I have a friend who is trying to figure this one out. He would like to know what database roles are available in the database(s) with the problem?

Really? Now that's not good!

Hang on here.

The error message indicates that SQL server thinks the table name is a keyword. Putting square brackets around the table name, or as SQL Server sees it,...

I believe you should be able to, just like you can use SQL 2005 SSMS to administer SQL 2000 database.

Just remember that there could be a few features that you...

I wonder what would happen if you prefix the table name with the schema and did not use the square brackets.

I'm not sure what that would prove, just curious.

Can you give us a few table names for tables where this occurs?

Are you interested in truncating, or rounding off?

What are you planning to do with the result? If you're going to display, or pass, it as a whole number,...