So to recap, here are 9 different methods for getting the current time, any additions anyone?

😎

SELECT

GETDATE()

,SYSDATETIME()

,SYSDATETIMEOFFSET()

,CURRENT_TIMESTAMP

...

Sean Lange (11/19/2015)

---

Jacob Wilkins (11/19/2015)

---

jasona.work (11/19/2015)

---

Luis Cazares (11/19/2015)

---

jasona.work (11/19/2015)

---

I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic...

Quick suggestion, convert the year to varchar

😎

Coming from a...

Ed Wagner (11/16/2015)

---

GilaMonster (11/16/2015)

---

Brandie Tarvin (11/16/2015)

---

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions...

djj (11/16/2015)

---

Brandie Tarvin (11/16/2015)

---

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing...

Can you please elaborate on the purpose of the subquery in the select statement (bold)? Any reason for not joining to the wheeltravelcard table?

😎

SELECT top 1 RFID

from wheeltravelcard...

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