Rafal S. created a script to get the job done.

See this link: http://www.sqlservercentral.com/scripts/Miscellaneous/62115/

Sorry, my mistake...

In SSMS you open the query. There you have to right click the query and then choose "analyse query in DTA"

Hi Bob,

Assuming there will be only one value in eacht column (per task_ID) you can use it with the GROUP BY clause.

The query will be like this:

SELECT TASK_ID, MAX(APPL_ID), MAX(QTIME),...

Hi,

You have to open the query in Management Server. From there you can select option "Database Engine Tuning Advisor" from the menu "Tools". This will pars the query to the...

Hi,

I quess you should use the UNION for this.

SELECT Column1, Column2 FROM Table1 WHERE Column1='cat' OR Column2='cat'

UNION ALL

SELECT Column1, Column2 FROM Table2 WHERE Column1='cat' OR Column2='cat'

UNION ALL

SELECT Column1, Column2 FROM...

Hi again,

On this website http://msdn2.microsoft.com/en-us/library/ms130828.aspx is a better explanation on what to use (and when to use it).

Hi,

SQLOLEDB is the best way to go.

On the MSDN website http://msdn2.microsoft.com/en-us/library/ms130978.aspx Microsoft states the following:

"If you are developing a new application it is recommended that you consider using ADO.NET and...