Below are 3 different methods for achieving the required results.

I'll leave it to you to test and find the best performance ...

Option 1 - Will have to be duplicated for...

You should have noticed that my partial solution only works if all of...

This hsould do the trick

Value = ((select ABS(CAST(NEWID() AS binary(6)) %25)) +1) *0.25

This looks like the main update can be achieved with a simple CTE to pre-aggregate per AcctNum and AgeBucket, joined to the #test_account for a single update.

;WITH cteAggregate AS (

...

This will list all the indexes in all the tables in your DB.

Modify the WHERE clause to filter the results.

SELECT

databaseName = DB_NAME()

...

It's an option.

I have had cases where this has resulted in improved performance from the UI perspective.

Done...

What about getting the app to make 2 separate calls, to 2 separate procs.

drew.allen (8/18/2016)

---

DesNorton (8/17/2016)

---

Unless my understanding is incorrect, I believe that the movement in this solution is the wrong way around.

To prove this, let's take a look at only the first...

drew.allen (8/17/2016)

---

I realized this morning that my code needed a slight update. My updates sample data had the same ordering for the from_seq and the to_seq, but that is...

Hi Jeff

Something went awry with your quote. Somehow the OP text was quoted under my name

WhiteLotus (5/29/2016)

---

Hi I have issue in my production server , The error is " An IDENTITY column has reached Max Int"

so I run DBCC CHECKIDENT('XYZ',RESEED,0); to reset the value of...

We don't know anything about your table, so here is something that works on my environment

;WITH cteBaseData AS (

SELECT [Timestamp], Customer

, seq...

John Mitchell-245523 (5/26/2016)

---

DesNorton (5/25/2016)

---

If you need an editable "computed column" ...

Create a standard column [NICKNAME]

Create an INSERT trigger that sets [NICKNAME] = [LASTNAME] + ' ' + [FIRSTNAME]

Then the column...

franklinkeith (5/25/2016)

---

Trying to create a computed column that can be edit.

LASTNAME + FIRSTNAME

I'm trying to be able to edit the computed column (NICKNAME) = LASTNAME FIRSTNAME and change to...

What about adding a new derived column and index to each table that creates a hash across the 30 fields. Then do a compare of the hashes.

ALTER TABLE <tablename>

ADD...