Hello All,

Please may I have your assistance with the following issue.

In T-SQL I'm returning 53 columns from a linked server running an MDX
query. Unfortunately except for the member caption which is being returned
as NTEXT the rest of the columns are returned as NVARCHAR(4000). I need to
reduce the size of the data types. I initially tried creating a temp table
with columns nvarchar(128) and then inserting the values into this table.
This worked well when I consistently return the correct number of columns,
however I have the added complication of the member caption not being
returned when there is no data.
Hence is there any way of altering the properties of the returned columns
when querying via a linked server using the MSOLAP provider?

Thanks
John

--
Message posted via http://www.sqlmonster.com