Post reply

How to Get Selected row values?

  • October 29, 2013 at 4:56 am

    #284364

    How to get selected row values using sql query?

  • October 29, 2013 at 5:01 am

    #1662279

    Do you want to copy them?

    Either write a decent SQL query that retrieves only the values you need and then copy paste it.

    Or copy paste everything to Excel and then delete what you don't need.

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

  • October 29, 2013 at 2:29 pm

    #1662537

    Send your sql query that you are using and can help with getting values you want.

  • October 29, 2013 at 9:23 pm

    #1662606

    Looks like homework to me.

    Start by explaining why you want the first row with the StudentID you've highlighted.

    Then look up ROW_NUMBER() in MS Books on Line.

    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St

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

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