sammy10691 (8/21/2015)

---

HI All ,

I Am faing a problem while calling the code using a link server .The query is able to...

coolchaitu (8/21/2015)

---

Dear Chris sir,

Openquery can tune/improve performance but the architect told not to replace linked server with openquery. This is because we are migrating to cloud and architect said that...

coolchaitu (8/21/2015)

---

Good morning,

There is a stored procedure. It uses linked server. As we will be migrating to amazon cloud, our architect instructed not to replace linked server with openquery. Please...

squvi.87 (8/20/2015)

---

Yes I...

Good catch Scott. I'd write it like this which is more or less the same:

SELECT m.reportMonth,

m.reportYear,

ex.[service],

SUM(m.Vol) AS Vol,

SUM(m.Effort) AS effort

FROM (

SELECT reportMonth,

reportYear,

queueID,

SUM(volume) AS Vol,

SUM(cost) AS Effort

FROM [cts].[exception_Main] -- 14.5M rows...

Sean Lange (8/20/2015)

---

Luis Cazares (8/20/2015)

---

Lynn Pettis (8/19/2015)

---

Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a...

sgmunson (8/20/2015)

---

serviceaellis (8/20/2015)

---

sgmunson,

thank you! This is closer than ever! It's producing the results in the detail format ...

Like J Livingston SQL came up with EXCEPT it was in a crosstab...

mufadalhaiderster (8/20/2015)

---

Thanks for all effort guys,

I am still getting an error message on the FROM, outer apply clause(Incorrect syntax near the keyword from)

OUTER APPLY (

SELECT

COUNT(*) AS FundedLastYear,

COUNT(CASE WHEN a.DateDetailDisposed...

-- create this index

CREATE INDEX ix_Helper ON [cts].[exception_Main]

(reportYear, reportMonth, exceptionDateTime, productArea)

INCLUDE (volume, cost, queueID, reportable)

-- run this query, capture the actual execution plan and post back

SELECT m.reportMonth

,m.reportYear

,ex.service

,sum(m.volume) AS...

mufadalhaiderster (8/20/2015)

---

I apologize guys..I posted in the wrong section. I have R2 and it is giving me an error

'DATEFROMPARTS' is not a recognized built-in function name'

any other techniques to...

mufadalhaiderster (8/20/2015)

---

I apologize guys..I posted in the wrong section. I have R2 and it is giving me an error

'DATEFROMPARTS' is not a recognized built-in function name'

any other techniques to...

Did you try the code I posted? Don't be shy about asking for explanations and further assistance.

SELECT ItemID, ItemName,

Price1 = MIN(Price),

Price2 = MAX(Price)

FROM #TBL_SAMPLE_DATA

GROUP BY ItemID,...

I'm planning on buying these at the weekend:

Grant...

Oh gosh :blush: I'm just a coder. You'll find this stuff as natural as counting on your fingers in...