What does the other xml file look like and what value/attribute do you need to extract from it?

Here's a solution based on Jacobs XML Lab.

It need to be noticeed that this will modify only one attribute. If you need to modify more/all attributes and the xml structure...

I'd say it's because of the Distinct operator in your query. Therewith you're using an aggregation similar to

GROUP BY D.Col1, D.Col2, D.Col3, D.Col4, D.Col5, D.Co6, D.Col7,

Agt.Col1, Agt.Col2, AH.Col1,...

+1

I just can repeat what I stated before:

Please read and follow the advice given in the first link in my signature and post ready to use sample data together with...

benjamin.reyes (12/30/2011)

---

I wish it worked that way. :hehe:

Though I'll settle for...

benjamin.reyes (12/30/2011)

---

Sounds like neither virtualization, nor throwing even more hardware at the problem will fix it.

We've had pretty good success in partnering with our vendors in sharing performance data such...

Please read and follow the advice given in the first link in my signature and post ready to use sample data together with your expected result and what you've tried...

WangcChiKaBastar (12/30/2011)

---

ok

Its actually an iterative call to a Stored Proc from .Net

and the proc runs super fast on SSMS. every call it fetches 2 to 3 rows and

returns data to...

The data in the file will be in the same order as specified in the original query. If there's no ORDER BY in the SELECT statement then you can't expect...

It's not really a duplicate post...

In this post the account number for "00011 0055500ABC" should be 0055500 whereas in the post Gianluca referenced the expected result is 0055500AB...

@mario:

I strongly recommend...

Thanx, Dev.

At least I didn't waste too much time on it...

Didn't see your latest reply, I'm sorry...

What is the logic to get "P" based on "0047225P1"? Shouldn't it be "1"?

Based on what you provided so far, this could be one solution:

SELECT '004722' AS [serial number] , 'P' AS letter

UNION ALL

SELECT '0055500AB' AS [serial number] , 'C' AS...

You don't need a function to return the values you're looking for:

In your sproc simply use the select statement:

SELECT

@UserFullName = chrFullName,

@UserEmail = chrEmail

FROM[User]

WHERE intUserID...