Thank you! That worked.

I was playing around and I got the first part

SELECT

top 2 'class1' as [@ClassName]

,AccountNumber as 'ExternalId' from Account

FOR XML PATH('Element'),type

--generates output

<Element ClassName="class1">

<ExternalId>3002543105</ExternalId>

</Element>

<Element ClassName="class1">

<ExternalId>3002651195</ExternalId>

</Element>

But not sure how I add "TYPE" in...

The data is just simple I have a table named  Account  that stores the account number

Table : Account

3002543105

3002543106

I want to keep the child data but just clear out the parent  table.

The data type is int for all columns . yes order by col1. Also there can be consecutive null values. But all the consecutive null values will be updated to...

• This reply was modified 5 years ago by  Guras.
• This reply was modified 5 years ago by  Guras.

Yes, the indexing on the FOREIGN  KEY on the referencing tables did it. Thank you !

Thank you  I will try this.

It has scan  to find the 1000 rows

code for the view

select top 200 key1 from [dbo].[Mytable1]

where key1 not in (select key1 from Mytable2)

order by Key1

--I was not ordering before still...

No processes nothing. I am the...

No, I am the only one running this query at the moment.