the results of your select are

FirstLastrn

TomJones1

JohnJones2

these are not the results I am look for thank you

Worked for me

then just sp_DropServer (name) droplogin

/* Basically I need to use the max(Rec_ID) + 1 in @OriginalTable to be the 1st number in the @NewTable

the RestofData cannot be used to join or...

Only one Report per file. So the first instance will be ok. In this case.

A completed version of the problem and solution

Declare @x xml

SET @x='<?xml version="1.0" ?>

- <AnalyticsReport>

- <Report name="Custom Report">

- <Title id="Title">

<CompareStateHelp>Compare report data to overall site performance and include report data...

Drew

I am not sure, I really don't know anything about XML

AnalyticsReport('(ProfileName)[0]','varchar(100)') as WebPage1,

c.profileName('(ProfileName)[0]','varchar(100)') as WebPage1,

c.value('(ProfileName)[0]','varchar(100)') as WebPage2,

none of these am I headed in the right direction?

Drew

How would I add the profileName to that select?

Mark

Thank you so much

Yes I did. ANd that solved the problem

:w00t:

Msg 9438, Level 16, State 1, Line 2

XML parsing: line 2, character 6, text/xmldecl not at the beginning of input

Drew

I really don't know anything about XML can you please be more specific. Yes please give me the exact code you used

thank you

Drew

SO I should load this into a xml type column and run this select against it?

Mark

msg 4108 Level 15 state 1 line 41

Windowed functions can only appear in the select or order by clause

I have tried this is does not work in an update statement

I need it to update the Put_it_Here column