Post reply

Computed column

  • November 9, 2010 at 5:33 am

    #1248170

    Nice but easy one.

    Thanks

  • November 9, 2010 at 10:15 am

    #1248416

    RichardDouglas (11/9/2010)

    I thought the title gave it away

    I don't normally pay much attention to the titles, since they sometimes are designed to be misleading. But yeah, that would have given it away too.

  • November 9, 2010 at 10:16 am

    #1248417

    Hugo Kornelis (11/9/2010)

    john.arnott (11/8/2010)

    Hmmm. When I run this code to build the table, "Select 1 from #test" returns two rows, each with a "1". It's an implied join, isn't it? . . . .

    Nope, no join at all. . . . .

    Thanks, Hugo. That's certainly clear and I did misuse the term "join". But my main intent in posting was to ask Sanjay (or anyone who could explain) why he got a 1 for his result set where I (and presumably you) would get multiple rows returned, each with the constant 1.

    He posted that after the two inserts,

    ...when you execute

    select 1 from #test

    you get result as 1

    Perhaps he meant to say "you get results as multiple rows of 1".

  • November 9, 2010 at 5:29 pm

    #1248640

    I interpreted Sanjay's post to refer to the double meaning of 1 - either an ordinal column position when used in ORDER BY, or an integer value when used somewhere else.

    But maybe Sanjay will return and add some clarification?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • November 24, 2010 at 11:46 am

    #1255253

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 16 through 19 (of 19 total)

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