Post reply

Select top 10 returns 101 rows...How ?

  • November 28, 2007 at 4:39 am

    #377196

    Hi,

    When I tried to fetch top 10 records of a particular view, it returned 101 rows.

    SELECT TOP 10 * FROM

    But, for rest of the views the same query is fetching only 10 rows.

    How this is possible ?

    Please clairfy.

    Regards,

    Ezhilan

  • November 28, 2007 at 4:49 am

    #754920

    Ties perhaps? Could you give more detail? How many columns, what type? What is the underlying view you are selecting from?

  • November 28, 2007 at 5:20 am

    #754925

    Hi,

    This is where view comes from...

    CREATE VIEW dbo.VW_ATSR_OETC_AUD_HIPO_SIDE_ONLY

    AS

    SELECT *

    FROM OPENQUERY(AM_ATSR_NV, 'SELECT * FROM openmsg.OETC_AUD where INST_BROK = ''I''') Rowset_1

    Please see the attachment for column names and datatypes...

    Thanks..

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

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