Post reply

Table Value Constructor 1

  • February 25, 2012 at 7:13 pm

    #252191

    Comments posted to this topic are about the item Table Value Constructor 1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 25, 2012 at 11:16 pm

    #1451791

    Nice question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 26, 2012 at 7:30 pm

    #1451864

    Good Question. Today I learned something new !!!!.

  • February 27, 2012 at 2:20 am

    This was removed by the editor as SPAM

  • February 27, 2012 at 2:31 am

    #1451934

    Nice constructor. Alas we are limited by older version.


    See, understand, learn, try, use efficient
    © Dr.Plch

  • February 27, 2012 at 2:54 am

    #1451940

    (sorry for cheating) but I really don't get it 🙁

    (by the way the question is really cool, i know remember one requirement which I had on the similar thing where there are two dates column and each can contain null and actually i need to list all the values in DESC (from both column) as one column, if A is null then take it from B....) I can understand this but I having hard time understanding the logic and the ways the SQL statement is written.:w00t:

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • February 27, 2012 at 3:49 am

    #1451964

    FFS worked the answer out but still selected the wrong one in the list. Must stop doing that - twice this year now.

  • February 27, 2012 at 4:09 am

    #1451971

    nice question !!!

    thanks Ron!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • February 27, 2012 at 5:25 am

    #1451995

    Thanks for the question. It was very useful, and presented in a way that required thought, but without parsing dozens of lines of text. Excellent.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • February 27, 2012 at 7:14 am

    #1452054

    To get my mind going I can think of no better way than answering the question of the day! Great question. 🙂


    Everything is awesome!

  • February 27, 2012 at 7:19 am

    #1452059

    Thanks for the ¿

    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

  • February 27, 2012 at 9:05 am

    #1452134

    Very good question.

    I really really really learnt a new good feature.

    Thank you a lot.

    😛

  • February 27, 2012 at 9:25 am

    #1452151

    Great question!!! Learned something new today.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • February 27, 2012 at 9:46 am

    #1452162

    great question. had to read more into this as I hadn't used VALUES in this way before.

  • February 27, 2012 at 12:06 pm

    #1452236

    Good question - made me think hard.

    When I first looked at it I hadn't a clue what it was doing, it took me quite a few minutes staring it and wondering what on earth it meant to realise that a single column table was being generated for each row of the starting table and the max taken from that.

    Good references in the explanation too (although as the question specified SQL 2008 R2 and Denali it was a bit odd to reference the SQL 2008 BoL page instead of the SQL 2008 R2 one).

    But something seems to be wrong with the wording of the explanation, I can't work out what the bit before the comma means.

    Tom

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

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