Jeff,

I have stumbled on what u mean bu taking a copy of the Table Schema as oppossed to using the overhead of XML as a before data & after data...

To proceed to troubleshoot this firstly, should we assume that TicketID has at least a NON CLUSTERED Index on it?

I should have said this in the initial post.

I wanted to see if it was possible to retrieve the CustomerType without using JOINS.

I already have written it to use JOINS...

Ok thanks.

Good solution as well.

Can Antonio please explain what the typo is in his code as I get an empty result set after executing

select * from dbo.fListToItems( 'a,b,c', ',' )

The first thing I would bedoing is to go and check if the Oracle Stored Procedure is in fact compiled without any errors in the Oracle Database.

If it's compiled, then...

It has everything to do with the time portion of '2008-03-01 24:00:00'

24:00:00 is no such value for a DATETIME Data Type. 24 needs to be 00

The way I would tackle...

Very difficult to advise you when we don't know what constitutes "A heavy Transaction Based System" as you have stated!

How many Transactions are you talking about? Have you measured that...

Yes both options worked well.

Thanks.

Thanks Adam.

Ok thanks Adam your example works.

Is this what's called XQUERY in your INSERT....SELECT?

Sandy,

How about an example of XQUERY that relates to my issue.

Greta to hear that XQUERY is better than openxml but give us an example with regards to my task!

Ok Thanks for that.

I'm using your method but I'm a little stumped as to how to retrieve the values such as CustomerID, OrderID, CompanyName etc by using xquery?

I had a...

Isn't Andras process a 2 step process as well?

What he is saying is to insert the XML file into a XML DataType Column in a Database and then Query the...

Ok thanks Ramesh.