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

Hi,

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,

S

Outcomes