Sorry Jeff, No I don't have the spare time at work that you seem to have. What I posted was intended to show anyone with a basic knowledge of...

Hmm, seems the only (?) way to put an image on here is to add it as an attachment.

So, the tablix in the first image file is produced by a...

Jeff, there's no such thing as "JUST some CASCADING CTEs!"

I have enough trouble trying to understand using just ONE CTE!

Also, an OVER is not "just simple arithmetic!"

I was just kidding...

I just noticed this thread: though Jeff's code is as always impressive (and as always, yet another plug for his Tally tables :rolleyes:), I can't help feeling it would be...

Erm, no. In that specific case the data was stored on servers...

Anyone who is not a US citizen, or not a US company, should be aware that data owned by non-US citizens but held on servers under US jurisdiction is not...

The OP didn't specify the data type of...

You are assuming the OP is dealing only with USA addresses.

In the UK, the equivalent would be 'postcode software,' and I imagine other countries have their...

tindog (6/2/2016)

---

cad.delworth (6/1/2016)

---

Personally it means that Italian restaurants (and of course coffee vendors like $tarbuck$) are totally off limits for me: and emptying my stomach on to their floor does...

You should ideally create two Parameters in your SSRS Report for the dates. If the dates are semi-static or are 'relative' dates (today, yesterday, a fortnight ago), use an...

Tindog, you have my sympathies (hopefully that's mutual?!).

I used to have one flatmate (US: a person I shared a condo with) who was so allergic to tea that even stirring...

Just the smell of coffee makes me want to vomit (literally).

Any workplace that has a coffee machine dominating it, is somewhere I will definitely NEVER take up a job, regardless....

Thanks for your suggestion, but without printing out the articles and writing the replacement text on them — or some similar method — my brain can't do that.

In the same...

Jeff: Thanks for the link(s). Still can't get my head around that "From TableA, TableB" syntax :sick:, so I'm afraid the other articles you linked to are near-impossible to...

Well I never! I genuinely didn't know that.

John: you're a star, and thanks.

Clearly my SQL education has been so Prim and Proper that I have never ever been introduced...