Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • RE: Tablix assistance please!

    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...

  • RE: Tablix assistance please!

    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...

  • RE: Tablix assistance please!

    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...

  • RE: Tablix assistance please!

    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...

  • RE: The Relentless Cloud

    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...

  • RE: The Relentless Cloud

    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...

  • RE: how to find number of days between successive visists?

    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...

  • RE: Function to get Number from word

    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...

  • RE: The Coffee Routine

    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...

  • RE: SQL Date column issues in query

    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...

  • RE: The Coffee Routine

    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...

  • RE: The Coffee Routine

    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....

  • RE: Master.dbo.SysColumns

    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...

  • RE: Master.dbo.SysColumns

    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...

  • RE: Master.dbo.SysColumns

    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...

Viewing 15 posts - 1 through 15 (of 23 total)