Further on Luis's post, do only one dateadd operation and use convert for the formatting.:cool:

Done this on exactly the same version/edition and the performance is brilliant so no worries there. One thing to check though is the configuration of tempdb, rule of thumb, recommend...

Further on mickyT's post, the cross row referencing window functions are perfect for this kind of queries, here is a quick sample.

😎

USE tempdb;

GO

;WITH SAMPLE_DATA(SD_ID,SD_DATE) AS

( SELECT * FROM (VALUES

...

Thanks for the question:-)

Got the same on 2014, non of the options...

Had few time-outs today, took me half an hour to respond to one post using the 3/4G on the mobile. Thought it was a carrier issue but then on a...

Grant Fritchey (10/15/2014)

---

BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all...

peacesells (10/15/2014)

---

I am bulk inserting a whole bunch of xml files into a sql table using OPENROWSET. The problem is that this process is really really slow. Any idea...

BOR15K (10/15/2014)

---

Eirikur Eiriksson (10/15/2014)

---

BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and...

BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all works like...

Congratulations Grant!

😎

Quick thought, you cannot execute the 2K5 function on the 2K server, the execution has to be in the scope of the 2K5 only. A workaround could be in the...

Quick question, why are you using the nolock hint?

😎

Quick note, for a...

Quick thought, this is in essence an unpacking of a period, either a calendar table or a tally table (virtual calendar table) will do the job. For the latter it...

Quick SQL Server 2000 solution, both limited and cumbersome but works

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE #SAMPLE_DATA

(

SD_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...