Do you mean that out of the 16 qry_id values in the table, you just want rows that match two of those qry_id values.

e.g. For table DEV_QRY_QC_HCC_131 containing these rows,...

Mine is a picture of me at work.

Marvin,

Can you please post expected results from that sample data - to clear up a few things that are bugging me?

I wouldn't mind if the rejection of that idea hadn't meant I spent time looking for other ways...:crazy:

after comparing/matching tblOrders.Amount=tblInventory.Amount, my goal is:

1. Update tblInventory set Inventory_Number=Orders_Number where isnull(Inventory_Number,0)='0'

2. Update tblOrders set Orders_Number=Inventory_Number where

isnull(Inventory_Number,0)<>'0'

I was very confused, there was a lot of record that have same amount...

You have to be careful about case sensitivity - ROOT changed to Root

SELECT

tn.value('@ID', 'int') ...

You did - I am watching a film 😀

hey no problem Lutz ... it happens

It will process the whole xml file.

To use it in an insert , it behaves just like any select statement.

Please try this version instead (went back to the cross apply...

mister.magoo (2/15/2011)

Based on your latest post, this should give you an idea of how to extract the data...

If you have any questions about what this is doing, just ask.

SELECT

...

Hi,

Based on your latest post, this should give you an idea of how to extract the data...

If you have any questions about what this is doing, just ask.

SELECT

trans.value('@ID',...

Hi Rich,

The problem is the following data - which causes the duplicates in Command.

AlertIDTreaterIDDTRaised Description ...

Hi Brandie,

Was there a state code with that error ?

Thanks Lutz 🙂

I was asking because you had coded it just for Savings, but I needed to know if it should be processing all accounts ...

I might not be able to...