AnsweredAssumed Answered

most of T-SQL commnads are not supported by PI OLEDB Enterprise

Question asked by Saken on Sep 28, 2016
Latest reply on Sep 28, 2016 by kduffy


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,