Forum Replies Created

Viewing 15 posts - 76 through 90 (of 178 total)

  • RE: To Infinity and Beyond

    seatedElephant (8/15/2016)


    My response was more on the subject of 'space tourism'.

    Ah, that does change the perspective and I can almost agree with you now. Might I suggest editing your...

  • RE: To Infinity and Beyond

    Iwas Bornready (8/15/2016)


    I've always wanted to be an astronaut. Sadly, now at 65, that won't happen.

    I feel your pain here. When I was a kid, I didn't have a...

  • RE: To Infinity and Beyond

    Jeff Moden (8/15/2016)


    From the Article:


    The explosion in aircraft ...

    Now, there's two words that should never be so close together in a sentence. 😀

    HA! I thought it was just me....

  • RE: Using LAST_VALUE

    Kathi Kellenberger (6/3/2016)


    EDIT: This is an answer to the question about using LAST_VALUE(TotalDue) OVER(PARTITION BY CustomerID, ORDER BY CustomerID)

    Also, the ORDER BY is not specific to how you want the...

  • RE: Using LAST_VALUE

    bhupendra.baraiya (4/16/2015)


    we can achieve the same output without adding the rows Cluse

    ...

    , LAST_VALUE(TotalDue) OVER ( PARTITION BY CustomerID ORDER BY CustomerID )...

  • RE: Resend Failed Scheduled Reports on Demand in SSRS

    This works great! Thanks for posting it! 🙂

    The only thing I had to change was the @sql variable datatype. I went with varchar(max) because we have...

  • RE: Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

    g.britton (1/28/2015)


    One of my favorite uses for APPLY is to make my queries DRY-er by pre-computing subexpressions. e.g.

    with data as (select * from (values

    (1,2,3),

    (4,5,6)

    ) v(a,b,c)

    )

    select a, b, f.future, d.diff, p.past

    from...

  • RE: Spousal Surcharges

    iposner (3/14/2016)


    ...appointments are prioritised on the basis of the gravity of the conditions...

    So if it's so good to be given a number and told to stand in line, why did...

  • RE: Spousal Surcharges

    andrew gothard (3/7/2016)


    djackson 22568 (3/4/2016)

    However what the media doesn't tell you is that every country that has national insurance has huge waiting lists for lots of things, including as much...

  • RE: Spousal Surcharges

    djackson 22568 (3/4/2016)


    Very nicely said, Andy, much nicer than I want to word it. 🙂

    I'll second that. I don't think Andy could have handled that any better. ...

  • RE: Forcing Strong Passwords

    I just experienced something new. Dropbox (which I don't often use) has a sign in feature, I enter my email address and instead of typing a password they have...

  • RE: Forcing Strong Passwords

    Wayne West (2/29/2016)


    There's an excellent article on this from the viewpoint of a professional computer forensic examiner.

    An eye-opening and jaw-dropping read! I know next to nothing when it comes...

  • RE: Forcing Strong Passwords

    When I see a site that doesn't allow special characters, I automatically assume they aren't scrubbing or analyzing their inputs and just don't want to deal with them, and we...

  • RE: Forcing Strong Passwords

    I've been tempted to rely, 100%, on the "I forgot my password" links on more critical sites. They all send an email (and I have a very secure password)...

  • RE: Openrowset returns an error when run from my WS

    GSquared (9/30/2011)


    ...So, if you connect from your workstation to a server, your workstation passes credentials to the server. That's "single hop" or "single step".

    ...but telling it to connect from...

Viewing 15 posts - 76 through 90 (of 178 total)