Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: In The Beginning

    TomThomson (11/26/2014)

    Carlo Romagnano (11/25/2014)

    Extremely easy!

    Thanks!

    But more than half the answers so far were wrong! (Probably because people forgot about negative integers, I guess.)

    Forgot about, and hadn't used, but conceptually...

    December 1, 2014 at 2:53 pm

    #1761881

  • RE: Unpivot

    Miles Neale (10/16/2014)

    After 5 pages of bloviation we get to the point of saying This was an excellent question and another great opportunity to learn something. I have not...

    October 17, 2014 at 1:58 pm

    #1753257

  • RE: Phantoms and isolation

    PHYData DBA (8/19/2014)

    TomThomson (8/18/2014)

    PHYData DBA (8/18/2014)

    1. I got this question "wrong" selecting the "right" answers sent out in email the next day.

    How interesting. ...

    August 19, 2014 at 3:16 pm

    #1739400

  • RE: Sub Query

    sknox (7/25/2014)

    At its heart, a correlated subquery is simply one that refers to data from the outer query.

    These are (non-correlated) subqueries:

    SELECT DB_NAME()

    , (SELECT count(*) FROM sys.objects) AS TotalObjects

    , (SELECT count(*)...

    July 28, 2014 at 7:12 am

    #1732825

Viewing 4 posts - 1 through 4 (of 4 total)