Hi.

I have solved part of my problem. I realised that the / character was part of the DateTime. I changed the stored procedure parameter to VARCHAR(20) and converted the time...

Jonnie Pettersson (2/13/2008)

---

Not much info but... http://support.microsoft.com/default.aspx/kb/235340

Quoted from Microsoft

"The SQL Server OLEDB provider (SQLOLEDB) has a new behavior designed to provide more accurate information to the caller about...

Jonnie Pettersson (2/13/2008)

---

Insert...

SET NOCOUNT ON

after the AS clause in your stored procedure (in the beginning)...

A recordset can contain meny recordsets...and your subquery will be the first recordset and...

Lowell (2/11/2008)

theory wiae, there's no problem using a function to return the table; the script contributions here on SSC has the famous SPLIT function, and I've used it plenty of...

Has the XML you are trying to work with got a namespace defined? If it has you have to set up the namespace in the sp_xml_preparedocument arguments.

My first and only...

Hi.

From vb set a reference to the ms xml library

Create an xml document object and load your xml document into it.

Call you stored procedure using the ADO command object and...