ScottPletcher (5/14/2014)

---

ChrisM@Work (5/14/2014)The execution plans for those two queries is likely to be completely different. If you were to write the query as a single "catch-all" query, it would be...

The execution plans for those two queries is likely to be completely different. If you were to write the query as a single "catch-all" query, it would be optimised either...

/* You missed out the ddl for table #C, the ReleaseNumber on the

last row of your sample data is probably incorrect, and your spec is sloppy

and...

Luis Cazares (5/13/2014)

---

I wouldn't use the cross apply, but it's just a personal preference.

It should be interpreted the same way as Chris M's query.

SELECT MeteriD,

Reading = SUM(Reading),

DateByHour =...

How are you timing this? It could take 35 seconds just to return this number of rows to...

Try this article on Dynamic Crosstabs[/url].

Had you read the article suggested by Jeff and others you would have posted this as INSERTs. We're now...

Megha P (5/13/2014)

---

Don't know performance wise it is good or bad..but i come up with below code

create Table #temp

(MeteriD INT,

ReadingDate DATETIME,

Reading INT

)

INSERT #temp

SELECT 3969,'1/01/2014 0:00', 0

UNION ALL

SELECT 3969,'1/01/2014 0:15', ...

Eirikur Eiriksson (5/12/2014)

---

Lynn Pettis (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

ChrisM@Work (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not...

Eirikur Eiriksson (5/12/2014)

---

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is there a way to display...

Hi Luis

Sorry mate, answered here. I hadn't noticed this thread or I would have put up a dupe notice.

;WITH DateRange AS (

SELECT EventDate

FROM (

SELECT

FirstDate = DATEADD(month,DATEDIFF(month,0,MIN(startdate)),0),

LastDate = DATEADD(month,1+DATEDIFF(month,0,MAX(enddate)),-1)

FROM #events

) e

CROSS APPLY (

SELECT TOP(1 + DATEDIFF(day,e.FirstDate,e.LastDate))

EventDate = DATEADD(day,ROW_NUMBER() OVER(ORDER BY (SELECT NULL))-1,FirstDate)

FROM

(VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (n),...

Can you set up some sample data for folks to code against? Coding up a running totals script is easy. Trying to imagine how your data looks before and after...

SELECT

'INSERT INTO ' + t2.table_name + CHAR(10) +

' (' + STUFF([target].ColumnList,1,2,'') + ')' + CHAR(10) +

'SELECT ' + STUFF([source].ColumnList,1,2,'') + CHAR(10) +

'FROM ' +...

Just to...