Jeff Moden (1/26/2016)

---

I'd take some heart in what was said as mean as it sounded. We have quick posts that don't survive the future and people saying they solved...

Quick suggestion, requires SQL Server 2012 or later

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE [dbo].[SampleTable](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Measure1] [float] NULL,

[Measure2] [float] NULL,

)

--Sample Data:

INSERT...

Microsoft ended the support for the Itanium architecture back in 2010, last versions supported were 2008R2 Windows Server and 2008R2 SQL Server. Superdome X uses the newer Xeon processors, totally...

cheshirefox (1/25/2016)

---

Hi -

I'm beginning the process of planning a physical server migration.

Due to our wildly volatile environment, we require physical database servers w/ data residing on a flash appliance.

Is there...

Looks like abdellahmoh2016 has left the building

😎

SumonB,

have you had a look at the solution posted here?

😎

Jeff Moden (1/25/2016)

---

Yes. Not because of the low quantity but because someone else in search of code may find it and use it on something larger or something that's...

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.

😎