I had to do this once before and the problem stemmed from SQL Server using a temp directory that wasn't accessible to everyone. In this case though I was using...

FYI - Problem seems to have been that Visual Studio Analyze was running. I turned it off under Tracing in the ODBC Administrator, and the query result time was reduced...

Thanks. I've visited that page before myself, but it doesn't give me much help with this situation.

I've used both methods of processing, and from my experience I would say the biggest gain was from inserting the data into a temporary table first. A cursor created from...

Here's another function that takes a simpler approach. If you are maintaining a holiday table, it would be simple enough to check the return value against it as well.

John

CREATE       FUNCTION...

From the little bit of information you gave it's hard to say for sure. It would depend a lot on how many columns, what your indexes are, etc. You can...

DBCC DROPCLEANBUFFERS didn't work, but I found that switching providers did as follows.

New: Works when original doesn't.

SELECT * FROM OPENROWSET("vfpoledb","\\wsipc-svr8\INTCALC\CALCULATOR\DRIVER_DBC\";"";"","SELECT DISTINCT * FROM CORPACHIST WHERE TraDate = {04/22/2005} AND...

I haven't yet, but I will the next time it happens. Thanks for the suggestion.

John

It's a bit hard to tell exactly what the problem is from your description. If you are returning results to through the query analyzer , then copying and pasting the...

Being someone who is also both in the DBA and developer role, my experience has been that Triggers are very useful tools if used judiciously.

In one case using a...

What I have done in this situation is create a stored procedure that calls the DTS package. In the DTS package I create Global variables to handle things such as...

I have gotten around this problem by calling the stored procedure that calls OpenRowset from a parameterized DTS package (Exec usp_ProcedureName ?,?,?) I use the package's global variables as input to the...