Great article Ray

Thanks

David and Marshall great for the input absolutly fantastic.

Thank you both so much!!!

Hi Marshall,

Sorry but can you explain whay this is bad?

When you put it out there, you have to give read and write access to the folder that the database sits...

Marshall,

Exatcly what I was looking for thanks a bunch!

I really do want to go with SQl Server I think it is silly sticking with...

Cheers guys. Will look into it.

Hi mkeast  ,

Your right thanks for the input. I have made the change and re reun the code from Visual Studio but...

Hi Manish,

Thanks for helping out. It's most likely a silly error on my part as i cant program to save my life.

Here is the table sql:

CREATE TABLE [dbo].[Import_Argentina] (

 [un_cid]...

any ideas  ???

Also removing the Insert will stop the insert.

The stored proc works in Query Analyzer when providing the xml as a string.

Changing direction of Parameter to input gives me an error of:

Procedure 'AddArgentinaTrades' expects parameter '@xmlInput', which was not supplied.

But I have added the parameter?

Any ideas?

Anyone any ideas ...? I'm certainally confused

Hi David,

No Same error!

Thanks for the reply.

any other ideas???? 

Please ignore the missing "I" in the "IF EXISTS" with regards to the SP. That is not the problem; that is me not being able to copy and paste.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ok problem solved an syntax problem.

Hi,

In the example above the I want to change the data type for @xmldoc from varcharr(8000) to text for the reason that me xml file will most likely be up to...