You could do this:

[font="Courier New"]SELECT * FROM (

SELECT TOP 10 * FROM Table1 ORDER BY ColumnA) X

EXCEPT

SELECT * FROM (

SELECT TOP 5 * FROM Table1 ORDER BY ColumnA) Y[/font]

This is...

Does the SQL Statement you are trying to run work, or does it get an error if you run it in Management Studio.

It looks like the jdbc driver is not...

Are you using a fiscal calendar, or a gregorian calendar?

In a gregorian calendar, weeks to months is a many-to-many relationship so you cannot create a hierarchy.

The generate script button is the first button on the table designer toolbar by default.

Also, when in the table designer, there is a Table Designer menu and it will be...

It really depends on the type of change. You should go back into design mode in a test envionment and try to make your change in Management Studio again....

More memory will probably only help if it is a 64bit OS. Much of the overhead of the multiple instances is going to be in memory that SQL Server...

I know your access is limited, but if you can terminal in and TNS ping the server, you should be able to terminal in and try to open/run the package...

What is the error message?

I agree it is all about how they do it. I certainly like to have prepared questions when I interview, and having someone write answers and then go through...

Are you sure it is a written test? It may have been communicated to you poorly.

I am a believer that there are questions that a non-dba can ask and...

If you are running a 64bit OS, you may want to consider adding some additional memory.

Run sp_configure or right-click on an instance in Management Studio and display the server properties. You can set min and max memory per instance.

Your SQL Agent account needs to be able to execute SSIS packages. It also needs to be able to access whatever store your package resides in. If you...

Perhaps you can post the error.

Don't just post the SQL Job Agent Error, turn on package logging and get the SSIS error.

Your question is pretty unclear. You talk about two temp tables, but the query you have included only has a single temp table it it. You are also...