How can I select this in Microsoft Query?

sql-server,tsql,microsoft-query

I solved this using this blog below http://blogs.office.com/2010/06/07/running-a-sql-stored-procedure-from-excel-no-vba/ basically in excel, when you click data tab - From other sources - instead of "from microsoft query". I select "from SQL server". With "from SQL Server". I have the option in the "Connection properties - definition" to select the command type...