SELECT TOP 1000 [RequestID]

,cast([Request]as xml) as test

,cast( [Request] as xml).value('(Request/AccountNumber)[1]', 'Varchar(9)') as AccountNumber

FROM [log]

Returns Null for the accountnumber

Thanks for the response. Substring is my fallback if I can't figure out an XML solution.

Records table:

ID | LNAME | FNAME |State Cd

----------|----------|--------- |

0000001 | Bloggs | Joe ...

Thanks all for your assistance. I believe you're right AB. While the sql did not return a result. I connected then did a right click on the...

The Connect To key does not exist. I have a last connect key which list the named instance.(SQLDev\Dev)

BTW I did not give the actual server names I gave an...

The named instance is in the registry. An alias does not exist. I apologize for not mentioning this earlier.

There is only one entry for ServerA\A

I see ServerA\A which I believe is the named instance.

1. What version of SQL Server is each instance?

Both ServerA and ServerA\A are 2008 Sp1

2. When you look at services.msc, are 2 instances showing up with MSSQLSERVER service? (i.e. is...

1. What version of SQL Server is each instance?

2. When you look at services.msc, are 2 instances showing up with MSSQLSERVER service? (i.e. is one analysis services or SSRS or...

Thanks Jeff Moden for the highly detailed answer.  This is exactly what I needed. I really appreciate the input.

I fixed the sql by using the variables from the first cursor to retrieve my rows in the second cursor. I'm only selecting the rows that match the pri keys...

Wow, that was great. Worked awesome

Thank you for the input. I think the sql solution will help.