K
Katherine Pacheco
Guest
I have the below select statement but i get error
Msg 7354, Level 16, State 1, Line 393 The OLE DB provider "STREAM" for linked server "(null)" supplied invalid metadata for column "CORP_POSTINGS". The precision exceeded the allowable maximum.
select
OfficeID, PostDate,
Case when a.OFFICEID in (''17'',''42'',''56'',''50'',''66'',''46'') then
a.PROVIDERNAME else ''All Providers'' end as Provider,
CASE WHEN a.JournalName contains ''emwell'' or a.JournalName in (''Insurance
Refunds'') Then sum(cast(ifnull(a.Amount,0.00) as decimal (12,2))) else 0
end as ''CORP_POSTINGS''
I tried ifNULL to the amount and it didnt work. I even tried ifnull and cast to decimal. Any help is greatly appreciated...
This is being done in OPEN PROGRESS ODBC CONNECTION
Continue reading...
Msg 7354, Level 16, State 1, Line 393 The OLE DB provider "STREAM" for linked server "(null)" supplied invalid metadata for column "CORP_POSTINGS". The precision exceeded the allowable maximum.
select
OfficeID, PostDate,
Case when a.OFFICEID in (''17'',''42'',''56'',''50'',''66'',''46'') then
a.PROVIDERNAME else ''All Providers'' end as Provider,
CASE WHEN a.JournalName contains ''emwell'' or a.JournalName in (''Insurance
Refunds'') Then sum(cast(ifnull(a.Amount,0.00) as decimal (12,2))) else 0
end as ''CORP_POSTINGS''
I tried ifNULL to the amount and it didnt work. I even tried ifnull and cast to decimal. Any help is greatly appreciated...
This is being done in OPEN PROGRESS ODBC CONNECTION
Continue reading...