Home Forums SQL Server 2005 T-SQL (SS2K5) Querying a Table Using Dynamic SQL RE: Querying a Table Using Dynamic SQL

  • March 3, 2010 at 11:59 am

    #1128007

    Jeff Kring (3/3/2010)

    I did look into ROW_NUMBER as an option. I could use it to return the correct rows, but the application needs the actual value as well.

    I don't understand what you refer to as "actual value". Please elaborate.

    The best way would be to provide ddl and sample data for two sample table including expected result so we have something to play with.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]