The proper syntax:

delete openquery(INTERFLOW02, 'select * from inventory.dbo.transmissions')

As illustrated in this article:

http://support.microsoft.com/kb/270119

Are you writing the file to a network machine or to the machine the database is running on?  I don't think you can write to a network machine.

As I recall the issues I ran into while starting out with BCP were permission related.  On the server the database is on, check what the service MSSQLSERVICE is running...

Lisa,

Thank you for taking the time to post a response to my question.  You definately got me on the right path.  I did uncover several errors as I'm obviously nowhere...

Thanks for the response.

I had already seen this posting (and many others).  Unfortunately, the link provided is no longer valid (http://support.microsoft.com/default.aspx?scid=gp;%5Bln%5D;gsserr404&style=error).

I did download the the dlls from Microsoft though...

Wouldn't you know I ran across an article shortly after I posted.

http://www.perfectxml.com/articles/xml/openxml.asp

And here's what I ended up with:

INSERT INTO PROSPECT

 SELECT *

 from OPENXML(@hDoc,'/adf/prospect/id',3)

 WITH

 (id int '.', source varchar(20) '@source',daterequested...

After playing with the xsd file this is what I got to work...seems contextType is case sensitive (vs contexttype)...

<?xml version="1.0" encoding="ISO-8859-1"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns:sql="urn:schemas-microsoft-com:mapping-schema"

elementFormDefault="qualified">

<xs:annotation>

<xs:appinfo>

<sql:relationship name="BetDetails" parent="Bet" parent-key="BetID" child="Selection" child-key="BetID"/>

</xs:appinfo>

</xs:annotation>

<xs:element name="Message" sql:is-constant="1">

<xs:complexType>

<xs:sequence>

<xs:element...

I was attempting to follow this example since everything was nicely provided.  This is my first attempt at import xml into SQLServer.  I got this error:

Schema: unable to load schema...

Thanks for clarifying why it didn't work.  I didn't know the in clause couldn't be the result of a query at runtime.

If I HAD to make it work with the...

Thanks David!  That is exactly what I was looking for.

Already got it pulling the data 😉

Thanks for your suggestions.  I'll give 'em a try today.

Thanks for your response.

I was hoping for more dynamic automated approach.  I wouldn't be able to push that solution out to a client.

I might mention this is for a report which will be pulled by users to check on success of service dept.  Run maybe twice a month.

Here is the sql statement:

select neworused52...

I decided to use a user defined function to determine the first oil change.  If there wasn't one, it just returns null.  I get the right results and the sql...

Well, so much for trying to be complete in my initial post..thought I covered all the bases.  Not sure what you want for sample data...just for me to list it...