The above post makes a good suggestion. The alternative would be to do something like

If @parameter = 'column1'

select column2, .., column N

from ...

else if @parameter ='column2'

select column1, column3, ....,...

Exexute Process task,

you state the likes of the working directory and type a command as you would in a CMD window. The command is specific to the app you...

Also if you haven't done so, try having the reports call a stored procedure and pass paramaters as opposed to building the query in the report. THis reduces network traffic...

So to put it plainly you are merely joining the table to itself where the from date of a given row is between the from and start date of another...

It appear you have your string inlcude the EXEC portion already. When you run EXEC (@osql) it seems to come down to

Exec Exec XP_CMDshell .....

ELiminating this may not not...

Just to cover the basics, is the table on a remote machine? Can you query other tables? I am just wondering if the issue is not an errant windows process...

I've seen this myself. There seems to be no pattern to the occurences. I wonder if it gets fixed with the application of the latest service pack.

Try tuning you indexes, NOLOCK is guaranteed to read uncommitted transactions but not necessarily guaranteed to improve performance.

Not sure of all the features of MySQL but it may have an import wizard that you would execute after you had your tables in place. Also don't forget to...

Just a note:

For every trigger defined on a table, SQL must run through the code of each to see what action, if any, is called for. Thus this may...

My understanding of an instance is that it acts as if it is another server without actually needing to buy another server. Thus I assume all the permissions/checkpoints you normally...

I tried querying using your suggestion on a couple of instances on one of our machines. I was not successful. Maybe I am missing something.

I have a similar report that runs on a schedule. Before I even published it I created to new datasets, one for the start time and one for the end...

In case you haven't , my recommendation is to learn on BOL about ISOLATION. Then also look at the indexes and tune those.

One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to travel...