Vijay,

If you're doing SQL Pass-through, you retrieve only the records you specifically ask for. What can you say about the first record that makes it unique?

If you're using SELECT TOP(1) ... you would have to order by some criteria, and if there is a "tie" for first you may actually get more than one record.


>Hi All,
>
>How can I get only one row using SPT? I could think of MaxRecords property but that if use it will be something like
>

=CURSORSETPROP("MaxRecords", 1, "MyCursor")

>In this case, I guess the remote server would have already fetched the entire result into cursor "mycursor" resultset even though I am interested in the 1st record of the result set and causing network delay. Am I missing something here?
>
>Thanks in advance
>
>Regards
>Vijay