in addition to the post of opc.three:

when using the users credentials (preferably through Windows Authentication) you could restrict rights of some users/groups. You could prevent users from accessing or updating...

I don't refer to the logical names, but to the physical names. The filenames of the new database can not be the same as existing filenames.

Because you use a backup...

Have you altered the names of the data- and logfiles of the new ABC database? They can't be the same as the physical names of the existing Y databases.

Unfortunatly I can't reproduce this issue on my system.

For testing purposes: what happens when you import the data using the "INSERT destination SELECT * FROM source" statement? Do you have...

Thats probably because "TotalSalesperProduct" is an alias and is not recognized by the parser. Replace it with the original statement will do the trick.

Oops... I didn't read carefully. You had allready added the ORDER BY.

Good effort, almost there....

You'll only need to select a TOP 1 and add an ORDER BY.

Because it is for your learning purposes, I will not post a complte solution :-P. But I will give you some pointers:

You still need to join Products and Sales. Take...

Check the settings in the "edit mappings" section of the wizard. Are you creating a new table or appending to an existing table?

Check for default values when you are appending...

It would be something like this:

....

from products1 p left outer sales67 s

ON p.prod_id = s.prod_id

WHERE s.date_of_sale >= '01-Jan-06'

OR s.date_of_sale IS NULL

As the url stated, this only applies to NON-clustered indexes....

Take a look at this article and scripts from Warren Campbell:

http://www.sqlservercentral.com/articles/Automation/76791/

There's no easy way to split an existing datafile. There are a few options, but keep in mind that most of them are very I/O and CPU consuming.

- add additional...

But how do you know you want the value "VAT" from col1 (4th row) and not the value "Bed+Vat"...

is a clear message of the problem, but it could have different root cause.

- the folder on disk (or disk itself) where...