spaghettidba (1/25/2016)

---

Eirikur Eiriksson (1/25/2016)

---

spaghettidba (1/25/2016)

---

It is a CLR function, so...

Quick test set, similar results to the one Jeff posted

😎USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_DATES') IS NOT NULL DROP TABLE dbo.TBL_DATES;

CREATE TABLE dbo.TBL_DATES

(

TD_DATE DATETIME ...

Luis Cazares (1/25/2016)

---

ben.brugman (1/25/2016)

---

I do strongly object to the notion that the default language is English.

I know in almost...

JustMarie (1/25/2016)

---

The ONLY business reason I can think of for this situation is a legal requirement that there be no gaps in the numbering. There's a vague memory of...

spaghettidba (1/25/2016)

---

Eirikur Eiriksson (1/25/2016)

---

spaghettidba (1/25/2016)

---

It is a CLR function, so...

spaghettidba (1/25/2016)

---

It is a CLR function, so there's a startup...

If I'm reading this correctly then the sproc returns sales by either a product, a customer or both. This kind of code is not likely to benefit from recompilation as...

Gianluca, don't use the format function, it has terrible performance.

😎

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