WITH dates AS

(

SELECT

*

,RowNo = ROW_NUMBER() OVER(PARTITION BY policyID ORDER BY startdate)

FROM ##myTable

)

SELECT

d1.PremiumID

,d1.PolicyID

,d1.StartDate

,EndDate = DATEADD(day,-1,d2.startdate)

FROM dates d1

LEFT JOIN dates d2 ON d2.PolicyID = d1.PolicyID

AND d2.RowNo = d1.RowNo +...

Blaze

dbursey (4/8/2016)

---

Hello - My report is landscape, 11 x 8.5. I have checked my body size (10.22); my margins are set at .25 on either side, so I should have...

Bridge

djj (3/31/2016)

---

BWFC (3/31/2016)

---

I've still got no real frame of reference on whether I'm getting the flavours right either. There's no smoking tradition in England and barbecue restaurants are thin...

Ed Wagner (3/31/2016)

---

ThomasRushton (3/31/2016)

---

BWFC (3/31/2016)

---

Nice!!! Two of my favorite things...ribs and poker. Add some dark malt beverages you have described my personal nirvana. Smile Myself I found a crazy deal...

Nice!!! Two of my favorite things...ribs and poker. Add some dark malt beverages you have described my personal nirvana. Smile Myself I found a crazy deal on pork shoulders. Full...

Ken McKelvey (3/30/2016)

---

Your problem is that postcodes are designed to direct mail so postcode districts do not always tie up with geographic areas of administration.

I suspect you are going to...

Jon-183221 (3/30/2016)

---

"If I could directly assign postcodes to a police force it would be much easier but as I said above I would end up with other problems."

Ok, scrap my...

ChrisM@Work (3/30/2016)

---

Jon-183221 (3/30/2016)

---

I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where...

Jon-183221 (3/30/2016)

---

I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where the...

I'll try to explain the best I can.

The basic set up is each postcode maps to part of a city or part of a county. Each city...

Sorry Chris but I'm really not following you. I'm still getting two rows for the EC1 area.

However, I've got something that is doing what I need now. It's...

Am I missing something there Chris? That just looks like my original code re-formatted.

Punctuality is important to me, if you're supposed to be there at 1000 be there for 1000. That, to me, means allowing enough time for the trip plus a...