Assuming you're trying to work with more than just a few rows per table (or more than one table) I'd consider keywords like CURSOR or WHILE as being a time...

I think you should take the time to provide some SQL code to explain what you're looking for (including expected result). Please see the link in my signature on how...

I'd recommend to shred the xml into a table with three columns (rowID, Field, Value) and either use a cross tab or a dynamic cross tab with this table.

If there...

Hi Regina,

please take the time to read the article I referenced in my signature.

This article will guide you through the steps on how to post sample data. Based on your...

May I kindly ask you to reread my previous post with focus on my last two statements?

Regarding your reply:

There is no way to come up with login names like MNT...

Well, you don't have to (as shown in my previous post).

Before looking deeper into OPENXML instead of XQuery I'd...

Hi,

in order to be able to use the value of an xml variable in a SELECT statement you have to assign it to a "pseudo column" using a FROM clause.

In...

Your sample data do not really match your verbal description.

First set of data:

You're describing repeated data in one column.

But your sample contains duplicate values in 4 columns (LOGINNAME, SHIFTID, ISLATE...

If you consider asking for table definition and sample data as "jibber jabber",...

As usual, the answer is "it depends".

If the xml file is not deeply nested and has just a few elements, performance difference over one or the other shouldn't be a...

I can think of only one option (since you've posted in SQL2K forum it's prior 2K5, I assume):

One of Jeff Modens great articles:

http://www.sqlservercentral.com/articles/T-SQL/63681/.

If you have trouble applying it to your...

What is the specific reason for using a cursor in this case?

You can join the TRLR table within your insert statement.

Also you should think about replacing the temp table #tmp_recs_cnt_C...

So, one of the business rules is "some companies have an edrs_no, but not all"?

In that case, either all rows per specific company should have an edrs_no, or none. Also...

We're getting closer...

As expected in my first post ("Check if your suspicious results have rows in wce_contact with the same company name, but none or different edrs."):

Rows numbers 2 and...

John,

you could leave out the comment for the next developer. It's pretty much self explaining, isn't it? 😉

I, personally, would have added much less explanation in a procedure or documentation...