wasifh

Run AF SQL Commander transposed View in SQL Linked server

Discussion created by wasifh on Oct 13, 2014
Latest reply on Oct 13, 2014 by michaelh

HI There I am trying to run a view created in PI AF SQL Commander from MS SQL Server Studio based linked server. I am getting the error of timeout. The view works perfectly in PI SQL commander but not in MS SQL. The view contains the PI SQL built-in transposed functions. Are the transposed functions not allowed in linked server or I am doing it wrong? Please let me know I am getting the normal archive data into linked server fine it's only this transposed data

Outcomes