I expect that the following extract will fail, as the max size of INT is 2,147,483,647 (10 Digits).

Even converting to BIGINT MAY fail, depending on the actual data, as the...

BOR15K (9/20/2016)

---

Hello,

Can one advise how to obtain file's details, please? Both xp_dirtree and xp_cmdshell return expected list of files, but I also need their properties: size and date.

Is it possible,...

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...