Quick suggestion

😎

DECLARE @TD DATETIME = GETDATE();

SELECT CONCAT(DAY(@TD),CHAR(45),SUBSTRING(UPPER(DATENAME(MONTH,@TD)),1,3),CHAR(45), YEAR(@TD));

Quick question, are you intentionally returning one row for each database file?

😎

Here is an alternative method for collecting this (almost the same) information in a single dynamic sql query.

😎

DECLARE @SQL_STR NVARCHAR(MAX) = N'';

DECLARE @OUTER_SQL NVARCHAR(MAX) = N'

;WITH...

Hugo Kornelis (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're...

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

ChrisM@Work (1/22/2016)

---

Ed Wagner (1/22/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Eirikur Eiriksson (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and...

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I...

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're going to reuse IDs...

ChrisM@Work (1/22/2016)

---

Ed Wagner (1/22/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Eirikur Eiriksson (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot...

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this...

Ed Wagner (1/23/2016)

---

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're going to reuse IDs that are primary keys,...

Jeff Moden (1/22/2016)

---

Eirikur Eiriksson (1/22/2016)

---

The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups in sequences....

Strongly advice you not to use the format function as it performs very badly.

😎

You have 15 minutes passed midnight in your query, if you need...

jcachado (1/23/2016)

---

Hi, i need help please,

Why this not work:

SELECT change_dtim,create_dtim,ckpt_id,Format([change_dtim]-[create_dtim],'hh:nn:ss') as tempo FROM Back_ickpt_plz where tempo > '00:15:00'

if i remove the where tempo > '00:15:00' , run .

What is my...

Luis and Jack, you are both right in the terms of suppressing the problem, preventing it is in my mind a better approach.

😎