Home Forums SQL Server 2008 Working with Oracle Excel Pivot Table shows zeros from a SQL View hitting an Oracle View via a Linked Server RE: Excel Pivot Table shows zeros from a SQL View hitting an Oracle View via a Linked Server

  • It is probably something that Excel should handle. It seems like a UniCode issue, but the source data-type is just Number. I thought there was also a possiblity that the problem could be in my SQL view code or linked-server settings. I included the SQL view code below. I spelled out the fields instead of using *, but it still has the problem.

    CREATE VIEW [dbo].[vwIMPACT_FEE_DATA]

    AS

    SELECT [Applicant]

    ,[Phone]

    ,[Address Line 1]

    ,[Address Line 2]

    ,[City]

    ,[State]

    ,[Zip Code]

    ,[Premise Address]

    ......

    ,[Meter Size]

    ,[Water Flow]

    ,[Water Supply]

    ,[Water System Dev]

    ,[WW Treatment]

    ,[WW Collection]

    ,[Service Line Total]

    FROM HANSEN..SAWS.VW_IMPACT_FEE_DATA

    GO