Thanks for your reply and I am trying to explain a bit more about my
query.
When I go through the Transfer documentation, it is mentioned that
transfer is currently supporting SQl Server 2000.
One of the features introduced in SQL Server 2005 is "ROW_NUMBER",
which will be used to fetch the records based on the row number. This
will help to retrieve only the required number of data in list page
which has the pagination.
For example, framing the below query is not possible in TQL, as it has
sub-query in the "FROM" clause.
SELECT Description, Date
FROM (SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)
AS Row, Description, Date FROM LOG)
AS LogWithRowNumbers
WHERE Row >= 1 AND Row <= 10
Is there any way to frame the above query as TQL?
Let me know if you need more details to get a clear picture of my
query.
On Oct 13, 3:56 pm, Jared Rypka-Hauer <[EMAIL PROTECTED]> wrote:
> Jerish,
>
> Are you asking if Transfer will ever support engine-specific features?
>
> If so (well, really, in any case) can you please clarify your
> question? I'm not sure what you mean.
>
> J
>
> On Oct 13, 2008, at 2:22 PM, jerish wrote:
>
>
>
>
>
> > Hi,
>
> > When can we expect the release to support the SQL Server 2005?
>
> > In our application we would like to use the pagination logic which
> > is part of the SQL server 2005.
>
> > Jerish- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
