Partitioning will help with the purging.

You have double posted this question. What version of SQL Server are you using, SQL Server 2012 or SQL Server 2014?

This is all you needed:

With cte As

(

select IntSequence, ROW_NUMBER() OVER (order by externalsequence asc) as rownumber from labels

)

update cte

set IntSequence = rownumber;

So something like this (run in an empty test database):

--Example table

create table dbo.Labels

(Id int identity (1,1),

Value varchar(20),

IntSequence bigint,

ExternalSequence bigint,

BatchId int)

-- Insert some data

Insert into dbo.Labels

(Value, IntSequence, ExternalSequence, BatchId)

Values

--batch 1

('exampleValue',...

Can you explain why you can't copy the ExternalSequence to the InternalSequence?

Eric Mamet (7/5/2014)

---

OMG!!!

I started the SQL Server Browser Service and can now connect to 127.0.0.1...

I can even access my server from another machine! 😀

Could someone try to explain this...

Hard to say with what you posted but looks doable. If you post the DDL for the table, some sample data (as INSERT statements), and the expected results I...

Jeff Moden (7/4/2014)

---

Pulivarthi Sasidhar (7/4/2014)

---

Hello,

We have been facing poor performance while inserting records using MERGE statment in SQL Server 2012 standard edition.

We are using dataloader of salesforce to download...

If the data is disappearing when the server is stand alone, no mirroring, then mirroring isn't the problem.

If the data is committed and then disappears it usually means someone has...

First suggestion, load the data to a staging table first. Then, when the data is local to database UPSERT the data to its final destination.

pilla.sree85 (7/4/2014)

---

I have passed createdDate from UI to Stored procedure.createdDate field declared with DateTime.it is having value 2014-07-01.I need to fetch records from the database based upon the created field.but...

If you are running the code in SSMS add the following after the PRINT. You can then click on the results and it will bring up the code in...

Jeff Moden (7/3/2014)

---

ksrikanth77 (7/3/2014)

---

Thanks Lynn for the code. It works as expected however the length of the @str Nvarchar(Max) variable is not enough to generate the complete select statement for...

Dell M4600...

And if you are so serious about eliminating the cursor, here is some code. Try it by itself in an empty test database. I have the insert part...