I have been linked to a professio historian who allows time periods in column names. Since the data is stored in non-DBMS format, I can not use the openquery to get the data because there is no set schema on the table, so to get the data, I have four part name syntax Have to use. Works with this example:
select iHist ... from [iTTrind from SELECT] but with the wrong syntax Fails' '.
Select from iHist ... [SELECT [SERVER.pid_astatus [07] [0] .F_CV.Value] ihTrend]] Where SERVER.pid_astatus [07] [0] .F_CV.Value is the name of the column
Also the fails with the wrong syntax from the keyword ' '.
Select from iHist ... [SELECT [SERVER.pid_astatus [[07]] [[0]]. F_CV.Value ihTrend]] Any ideas on how can I view SQL Server as a single column?
Edit:
To avoid bracket, Martins suggestions only work out of SQL Call
SELECT [SERVER.pid_astatus [07]] [0]]. F_CV.Value] From IHist .. [select IhrTrend] However this does not work within the 'incorrect syntax' with the keyword 'from'.
Select * FROM iHist ... [SELECT [SERVER.pid_astatus [07]] [0]]. IhTrend from F_CV.Value] Edit SELECT * ... [SELECT [SERVER.pid_astatus [ 07]] [0]]. > This is only for you ] / P>
[pid_astatus [07]] [0]]. F_CV.Value]
This works for me
create table # t ([pid_states [07]] [0]] .fcv.value ) Selection [PID_States [07]] [0]]. FCV. By value # t
Comments
Post a Comment