For some reason I get the error

In the FOR XML EXPLICIT clause, mode 'ELEMENTXSINIL' in a column name is invalid.

when I have NULL AS [stockHeader!3!supplierName!ELEMENTXSINIL],

. I'll go with the ISNULL...

That worked for me - thanks for the info:-)

interesting -

The following returns nothing

SELECT BOM_REQUIRED,Company_Code,FACTORY,DEPARTMENT from OPENQUERY( AGILtest, 'SELECT BOM_REQUIRED,Company_Code,FACTORY,DEPARTMENT FROM AP_GENERATE_PICK WHERE Company_Code =''A'' AND FACTORY = ''2'' AND (BOM_REQUIRED=''N'' OR DEPARTMENT=''24'')')

however this does return a value

SELECT...

I should add - the data is there to be updated, it's not that the query is wrong.

yep - will change the language setting in the script - thanks for the help

It appears that my issue is in fact down to data. This code worked before on an older server. I thought it was a 2000 V 2008 issue but in...

Sean - I think you might be right

It happens for any row in my data set. I just bring back the one field causing my problem like so

SELECT TOP...

setting the language at the top of the query in Excel fixes this - but just think its strange that the language settings in Excel overrides the SQLServer Databases settings

thanks...

thanks - what I don't understand is that I'm connecting to the same database, just using 2 different ways. I'm not setting the language to anything in my connection or...

thanks - it doesn't cause an error and looks like its ignored. Just wanted to confirm.

so the problem is where the cursors are being used then? These need to be selecting data?

Hi all,

Still not figured out this problem with BCP.

I'm using a table variable here not a temp table. The SP code I'm using is below. Can anyone see anything...

Thanks.

I'm using a table variable rather than a # table. I have bcp working with a stored proc that uses a table variable, but for that file the first row...

bingo - I am an idiot:hehe:

have been doing this for hundreds of sps - had opened a 2000 session which worked but of course that's because it was a fresh...