When calling SOA service from SoapUI, I configured the request properties with UN & PWD. Then call went fine

When calling SOA service from the application, I added security...

Solomon Rutzky, Thank you so much for the quick reply.

Here are the 4 methods that I tried. None of the these methods are adding SOAP headers in the SOAP message....

Thanks for all the replies...

As Sean Lange suggested, I tried with temp table (instead of temp variable).

I faced these problems.

1. I have to build the sql statement. So I...

Ray M,

Thanks for the quick response...

I don't know the column type to declare the table variable initially.

I have to query sysColumns table to know the columns and then I...

Scott D. Jacobson, your advice worked.....Thank you.

Service is defined with XSD, so,I receive data as a list.

Thanks & Regards,

Jeff Moden,

Thank you for the response.

I am receiving a list of 50000 records from a service.

I am planning to write a stored procedure with table-valued parameter and then...

laurie-789651,

Thank you for the suggestion. I will try this.

Matt Miller (#4),

I tested this with BCP command.

If I try to execute the BCP command without entering any delimiter, it is giving error "Enter the file storage type of field...

Mark Fitzgerald-331224

When viewed with notepad, i can see where the CR\LF characters are inserted. when wrap is on...then also data is coming to the next line where ever CR\LF exists.

When...

Thank you very much for everyone for the quick response.

My sql query to generate xml is

select top 50000 col1,col2,col3,.....col1000

from Table1

FOR XML PATH('Record'), ROOT('Table1')

When I execute this query and save...

I am trying to generating the xml file (huge) from the sql query. This xml file is having carriage returns in the xml nodes

Here is the script that I am trying to use to get lastUpdateDate....as "2009-10-07T15:19:23.000" from the xml file

DECLARE @hDoc int

exec sp_xml_preparedocument @hDoc OUTPUT,'<Rows><row><lastUpdateDate>2009-10-07T15:19:23.000-04:00</lastUpdateDate></row></Rows>'

SELECT XMLTable.lastUpdateDate lastUpdateDate

FROM OPENXML(@hDoc, 'Rows/row', 2)...

My requirement is as the following

My xml file from web service:

<Rows><row><lastUpdateDate>2009-10-07T15:19:23.000-04:00</lastUpdateDate></row></Rows>

I am pulling data into the temp table like the following:

...

I tried like this...

SELECT convert(datetime, '2012-08-01T15:05:13.000', 126) --> this is working fine

SELECT convert(datetime, '2012-08-01T15:05:13.000-04:00', 126) --> but this is not