problem in select command

  • First one who writes after this post will be raped by a mad goat! :w00t:

    😀

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths
  • You may use below query to achieve the same result (if the query is running on SQL Server 2000 or order version)

    ---------------------------------

    SELECT * FROM

    (SELECT TOP 2 *

    FROM DBO.NFFeeds

    ORDER BY ID DESC) x

    ORDER BY ID ASC

    ---------------------------------

  • Moderator, please close this thread as nonconstructive.

    I tried with mad goat method, but it turns out it did not work 🙂

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths
  • Vedran Kesegic (3/20/2013)


    Moderator, please close this thread as nonconstructive.

    I tried with mad goat method, but it turns out it did not work 🙂

    More than that! It not only didn't work, it also managed to offend innocent fellow :crying:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • More than that! It not only didn't work, it also managed to offend innocent fellow :crying:

    Did you noticed a smiley next to the message? But I don't know who would take a mad goat as something serious, even without a smiley 😛

    Non-constructive thread with too many messages, not very useful IMHO.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

Viewing 5 posts - 46 through 49 (of 49 total)

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