Viewing 15 posts - 1 through 15 (of 23 total)
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...
August 18, 2016 at 8:13 am
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...
August 18, 2016 at 6:27 am
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...
August 18, 2016 at 2:39 am
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...
August 17, 2016 at 2:20 am
Beatrix Kiddo (7/20/2016)
I believe a recent ruling declared that data in the EU is exempt from this?http://www.wsj.com/articles/microsoft-wins-appeals-ruling-on-data-searches-1468511551
Erm, no. In that specific case the data was stored on servers...
July 22, 2016 at 2:05 am
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...
July 20, 2016 at 2:22 am
drew.allen (7/11/2016)
The reason that you were getting bad results is that your "dates" aren't really dates. They're strings, so they sort alphabetically.
The OP didn't specify the data type of...
July 12, 2016 at 2:18 am
Jeff Moden (6/13/2016)
CASS Certification software
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...
June 14, 2016 at 2:14 am
tindog (6/2/2016)
cad.delworth (6/1/2016)
June 2, 2016 at 5:51 am
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...
June 2, 2016 at 2:30 am
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...
June 1, 2016 at 5:30 am
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....
June 1, 2016 at 2:28 am
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...
April 12, 2016 at 8:53 am
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...
April 12, 2016 at 8:22 am
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...
April 12, 2016 at 4:24 am
Viewing 15 posts - 1 through 15 (of 23 total)