Post reply

Query output less number of records?

  • June 10, 2012 at 10:30 pm

    #262253

    Hi,

    Total 3000 Records, executing query 2300 records only display, please tell me what could be reason?

    thanks

    ananda

  • June 10, 2012 at 11:09 pm

    #1499139

    ananda.murugesan (6/10/2012)

    Hi,

    Total 3000 Records, executing query 2300 records only display, please tell me what could be reason?

    thanks

    ananda

    Because Sql Server, after compiling your query, doesn't think that the rest of the 700 records should be part of your result set.

    With 636 posts you sure must know how to post a question in a Forum and I don't need to tell you how to do it.

    Please post the query and the DDL of the tables.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Viewing 2 posts - 1 through 1 (of 1 total)

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