rameelster (11/20/2015)

---

DB server consists of Inter Xeon processor(2 Processors) with 40 cores and a memory size of 64 GB. I have allocated 61 GB for sql server and the rest...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Test') IS NOT NULL DROP TABLE #Test;

Create Table #Test

(id int identity,C1 bit , C2 Bit , C3 Bit)

insert into #Test Values (0,0,0)

...

Jeff Moden (11/19/2015)

---

There are many more but, just to wet the appetite for other possibilities...

SELECT {fn NOW()};

SELECT {fn CURRENT_DATE()} + ' ' + {fn CURRENT_TIME()};

EXEC...

Couldn't fit it in the select statement, too many EXEC'y thingies in there, any alternatives?

😎

Alvin Ramard (11/19/2015)

---

Eirikur Eiriksson (11/19/2015)

---

That looks way too close to a union all statement...

That looks way too close to a union all statement for comfort:-P

😎

How come?

😎

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