Quick question, can you post the DDL (create table), some sample data as an insert statement and the expected results, without that one can only guess. The subquery in the...

Quick question, when emptying the roles of users, do you check for any ownership of those users?

😎

Just a quick test to play around with, notice the effect of adding an index

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE BIGINT = 10000000;

DECLARE @INT_BUCKET ...

Sean Lange (11/13/2015)

---

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of rows in the select...

Sean Lange (11/13/2015)

---

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of rows in the select statement are not guaranteed...

Lowell,

did you find anything useful for this?

😎

Sean Lange (11/13/2015)

---

TomThomson (11/13/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the...

Yes the rows will be in a consistent order.

😎

Quick thought, since you are on 2012 it's probably easier to use the OFFSET FETCH rather than the WHERE clause. Further, when...

Respect!

😎

Think English sarcasm mixed with Icelandic frigid humor:-D

😎

Must resist.......

SELECT STUFF(I.T,1,5,'UP') FROM my... AS...

MUST Resist...temptation...bad...joke!!

😎

+200

😎

That's quite good:-D I might be...

info 58414 (11/12/2015)

---

Hi,

I aggregiere data from a table, and should get the max 3 Sales Amount.

If the Customer has only 2 sales, is a DummyRow be issued with value 0;...

Quick suggestion, look into sparse columns for this one, found it to be one of the more efficient mechanisms for handling this.

😎