Hi to all.
I need to pull data from PROGRESS DB versione 10.2.b to a SQL SERVER Table using SSIS of MICROSOFT.
I connect using ODBC Driver Client Access 10.2.b
All is ok but i need an help to do the SQL Query.
I need to obtain ONLY one row from multiple records.
I need to obtain ONLY the record with MAX(Date)
In T-SQL query should be like that :
select userid, my_date,...from
(select userid, my_Date,... max(my_date)
over(partitionby userid) max_my_date
from users )
where my_date = max_my_date
I did not find anytihing of similar using SQL Openedge..
Is it possibile to do that ????
Regards.
I need to pull data from PROGRESS DB versione 10.2.b to a SQL SERVER Table using SSIS of MICROSOFT.
I connect using ODBC Driver Client Access 10.2.b
All is ok but i need an help to do the SQL Query.
I need to obtain ONLY one row from multiple records.
I need to obtain ONLY the record with MAX(Date)
In T-SQL query should be like that :
select userid, my_date,...from
(select userid, my_Date,... max(my_date)
over(partitionby userid) max_my_date
from users )
where my_date = max_my_date
I did not find anytihing of similar using SQL Openedge..
Is it possibile to do that ????
Regards.
Last edited: