I'm looking for help from T-SQL in PI OLEDB Enterprise, I figured out that most of T-SQL commnads(see example below) don't work and are not supported by PI OLEDB Enterprise,
it's really worse since we can't do anything with what currently exists.
select row_number(*) over (partition by column_name1, column_name2 order by column_name3)
select datediff (minute, end_date,start_date)
select isnull(max(d),0) as d from @t
thank in advance,