Import from SQL Server Stored Procedure - first column not importing, and Order By not honored

Nola111

Board Regular
Joined
Aug 28, 2013
Messages
119
I'm using latest version of Excel from M365 on Windows, and Azure SQL Server 2017.

When I import the results of a stored procedure, it doesn't import the first column, and it doesn't import the data in the order indicated by the ORDER BY clause in the SQL Stored Procedure. When running the SP in SQL Server Management Studio, the results look exactly as we would expect.

I am connected to the database using Data-> Get Data, and from there created a connection. The Stored Procedure is being run per the method shown in this tutorial video:

I'm not getting any kind of error message that would indicate why I'm missing the first column.

Any thoughts?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Nola111

Board Regular
Joined
Aug 28, 2013
Messages
119
First column issue is resolved. I've opened a new thread for the Order by issue. I didn't realize I can't delete this thread when I created the other one.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,087
Messages
5,640,032
Members
417,121
Latest member
kirk5370

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top