I have the below query:
Select tmp.* from openquery( [LinkedServerName], 'select * from viewname1' ) as tmp.
When I executed this query, I am getting below error. Could you please help?
Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "LinkedServerName" supplied invalid metadata for column "columnname". The precision exceeded the allowable maximum.
Column Details at Source (Progress): (As I don't have any form of access to Progress DB, I am not able to provide you its version)
Field Name Field Label DataType Format Extent Initial
DailyBalance Daily balance decimal zz,zzz,zzz,zz9.99- 12 0
In SQL Server:
Field Name DataType Format
DailyBalance Numeric (26,2) - Based on existing program guidance from team management, I doubled the size in SQL Server compare to Progress.
Basically, I am pulling all records from ODBC View thru Linked Server and storing into a local table type variable. Then insert into a permanent table. All theses are in procedure.
Before I executed the procedure, I wanted to check thru manual execution. But keep getting the above error. I increased the format to numeric (30,2), (30,4) but no luck.
Your prompt help is greatly appreciated