What is your expected output based on the sample data provided?

Since you have a named xml doc you need to use the namespace declaration in your query.

I don't know if...

You're welcome!

That's exactly the attitude that's needed: get an idea/code snippet, do some research, learn how it works and modify it to your needs. Excellent job on your side!!!

Why not

1 1 jane doe

3 2 joe doe

What's the rule to select one name out of many? Min(id), Min(name), max(name) or something else?

Depending on the number of rows and whether the data can be aggregated asynchronously or not I would either use

ROW_NUMBER() OVER(ORDER BY RowId ) - ROW_NUMBER() OVER(PARTITION BY RowType...

@derrick: I didn't copy your code! Honestly! ;-):-D

Based on Ninja's_RGR'us code snippet:

SELECT LEFT(@str,LEN(@str)-CHARINDEX('\', REVERSE(@str), 1))

Would you mind providing some sample data that reflect table structure and data structure (e.g. How can the checkpoint rows be identified? Is there an identity column? or the like)

Use ROW_NUMBER() OVER(PARTITION BY Rx_Nbr ORDER BY System_ID) as pos in a CTE (or subquery)

and select the data using

SELECT

Rx_Nbr,

MAX(CASE WHEN pos=1 THEN NewNDC_Nbr ELSE...

Hi Forum Newbie ( 😉 )

At a first glance: it's the same issue like the first file:

There is a line where the default namespace is reset to an empty string:...

I think we're all intrigued by the why, but there's one thing I consider being worse.

And it's not Jack and Jeff being rejected. It's the way the decision has been...

I didn't know you're trying to add some value to a 3rd party app ... 😉

Do you know the table structure and how you need to query it to get...

If you only need to know if a client id exists use EXISTS instead of COUNT(). See Gail's related blog[/url].

Side note: Is there any index on clientId to support...

The lock icon basically means you don't have the permission to view or modify it.

I'd recommend you get someone with the proper permission asking him to give you a function...

There is simply not enough information to give any advice.

What do you mean by "is locked"? What is the purpose of the procedure? What is the structure of that "list...

I would use XQuery over OpenXML.

However, I had to change your sample data:

Your row < NewDataSet xmlns="" > will result in an XQuery error since you need to use valid...