MS Query executes stored procedure but not returning text

Asked Apr 03 '17 at 01:39

Active May 03 '17 at 20:35

Viewed 83 times

I am executing a stored procedure via MS query to and Macro Enabled Spreadsheet.

When I I execute it it returns data except for my two description fields.

When I execute the stored procedure in SQL Server, it executes correctly:

    LEFT('All hospitality goods, equipment, and or items described in the Rental Agreement to the debtor supplied from time to time by Silver Chef Rentals Limited - ' + Cast(ad.SerialNumber as varchar) + ' - ' + ad.AssetDescription,199) AS CollateralItemDescription
, 'All hospitality goods, equipment, and or items described in the Rental Agreement to the debtor supplied from time to time by Silver Chef Rentals Limited - ' + CAST(ad.AssetTag as varchar) + ' - ' + ad.AssetDescription as CollateralItemLongDescription
, LEN ('All hospitality goods, equipment, and or items described in the Rental Agreement to the debtor supplied from time to time by Silver Chef Rentals Limited - ' + STUFF((SELECT ', ' + ad2.SerialNumber + ' - ' + ad2.AssetDescription FROM AssetDescription ad2 WHERE rf.ContractNo = ad2.ContractId FOR XML PATH(''), type).value('.', 'nvarchar(max)'),1,1,'')) AS LongDescriptionCount

Is there some sort of character limit or do I need to convert?

It seems odd to me.

edited Jul 09 '18 at 18:41

Community

asked Apr 03 '17 at 01:39

Lucas Perrett

hi which fields? – RoMEoMusTDiE Apr 03 '17 at 02:23
CollateralItemDescription and CollateralItemLongDescription – Lucas Perrett Apr 03 '17 at 02:31
reckon would be a data type mismatch in excel, first start with the length of varchar.. i.e. varchar(max) or varchar(100) – RoMEoMusTDiE Apr 03 '17 at 02:32

MS Query executes stored procedure but not returning text

0 Answers0