Selecting a column with period in the column name SQL Server -


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