Sounds like you probably will need to pay someone to have a proper look then and, unfortunately, that would not be me. The only other thing that immediately occurs to...

Are you certain that your ERP system was designed for, or optimised for, (your particular version of) SQL? Our off-the-shelf ERP software was originally written many years ago for Unix...

ALL: Apologies for the delay in replying but I have been away.

Ian, adding a WHERE clause does indeed dramatically reduce the time taken (after the first time it has been...

Actually the answer was quite simple: quite why I am not sure, but on our system all these objects are defined with upper case names and have to be referenced...

I admit my SQL knowledge is extremely limited, but am I missing something very basic here? All I get is an Error 208 - Invalid Object Name INFORMATION_SCHEMA.Tables. It would...

I seem to recall that we had performance issues when we installed SP4. Never had a satisfactory answer, but discovered that it was largely due to the way SP4 was...

Hi

I have encountered similar problems with our ERP software when trying to extract 'date fields' via ODBC. I get similar messages implying that there is an invalid value in one...

I have only ever used the DTS Import wizard before and simply let it dump the spreadsheet in as a table. I see that there is a 'transform' button in...

Ryan:

Many thanks for this, but it seems to require the values to be manually included in the code. The whole point is to avoid this otherwise I could have manually type...