chandan_jha18 (3/21/2016)

---

Thanks Lowell. The NULL and the Or clause are business rules so won't be able to find my way around that.

I will try breaking the master proc and test...

craig.bobchin (3/21/2016)

---

I tried that and still got the error . This time it said the error was at the alias not the ).

matak (3/20/2016)

---

You need to give your

select *

from...

ChrisM@Work (1/18/2016)

---

Jeff Moden (1/18/2016)

---

ChrisM@Work (1/18/2016)

---

Jeff Moden (1/18/2016)

---

ChrisM@Work (1/18/2016)

---

With the battles...

Couple of minor tweaks:

WITH SequencedRows AS (

SELECT

p.ClientId,

h.StartDate,

h.EndDate,

cp.CoveragePlanName,

rn = ROW_NUMBER() OVER (PARTITION BY d.clientid, d.coverageplanname ORDER BY d.StartDate)

FROM ClientCoverageHistory h

INNER JOIN ClientCoveragePlans p

ON p.ClientCoveragePlanId = h.ClientCoveragePlanId

INNER JOIN CoveragePlans...

No; but there are two common ways around this. Either resolve out the string to a table of values and join to it, or write the statement as dynamic sql.

Incidentally,...

smithhead (3/17/2016)

---

Thanks everyone. I can post more details later, but here are some quick comments/questions:

Good to know about compute scalars, I was wondering what that meant.

What do...

Jeff Moden (3/16/2016)

---

That's a serious matter of opinion. I think they flubbed it in two ways...

1....

There's no warning on the result operator to back this up (if the warning string is too long to display in the "hover over" property sheet, it can still be...

I'd strongly urge you to spec out the functionality of

EXEC [dbo].eusp_e5_eSM_SE_GetHistoryForItem

and focus on this. It's the meat on the bones of this report.

Emil B (3/16/2016)

---

The main problem is that on our fast drive we are slowly running out of space, we have another, slower, drive that we could use. We are planning...

Phil Parkin (3/15/2016)

---

Indeed. Why...

Sean Lange (3/15/2016)

---

ChrisM@Work (3/15/2016)

---

Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a...

Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a huge amount of...

Junglee_George (3/15/2016)

---

I have added the statement SELECT @@NESTLEVEL in my query at different points in the stored proc eusp_e5_eSM_SE_GetHistoryForItem.

But everywhere it is returning a value 0, even at the previous...

Sure:

;WITH sample_data (resultA, resultB, resultC, resultD) AS (

SELECT 'chicago', 'ID123', '20pax', 'ID123' UNION ALL

SELECT 'austria', 'ID999', '90pax', 'ID999' UNION ALL

SELECT 'Spain',...