Stored Procedure Error "No Columns Returned"
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We connect to a remotely-hosted SQL Server 2008 DB on which we can execute Stored Procedures, however we have no ability to edit/write Stored Procedures (or even see the code through which the exisiting SPROCs were created).
In SQL Server Management Tools, we are able to return results using the code below. However, no matter what I try, I am unable to return results in Alteryx -- and unfortunately, no one at our organization is a SQL expert (including myself, needless to say :-) ).
Any leads, suggestions, workarounds appreciated!
thanks,
marshall
USE [Database1] GO DECLARE @return_value int EXEC @return_value = [dbo].[spRPT_Annual_Report] @Reporting_Period = N'Use Custom Period', @StartDate = N'12/01/2014 00:00:01', @EndDate = N'11/30/2015 23:59:00', @Universal_or_Grant_Report = N'1 - Universal' SELECT 'Return Value' = @return_value GO
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you try creating the same query using an OLEDB connection? That was all I needed to change in my setup to get results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the suggestion. The OLEDB connection has unfortunately not worked either.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- « Previous
-
- 1
- 2
- Next »