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.

😎

This one is going to be worth watching!

😎