Post reply

Tally Tables and Table Variables

  • November 14, 2017 at 7:35 pm

    #1968112

    Jeff Moden - Sunday, November 12, 2017 10:27 AM

    Eirikur Eiriksson - Sunday, November 12, 2017 8:21 AM

    Lesson for those who got this one wrong, AS in the column definition within the DDL means that it is a computed column.
    😎

    Lesson even for those that almost got it wrong because of poor eye sight... enlarge the code and read it carefully with your glasses on. 😉

    That would be me.  Only, it wasn't almost.

  • November 21, 2017 at 9:08 am

    #1969013

    A nice tricky one. Although I got it correct through eliminating out the other options and looking suspiciously at the C1 column rather than matching the answer straight away.

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply