I have a query that runs super fast in SQL Studio. I have copied this into MS query and it shows the results in teh MS query window, but when I click return data nothing is returned to Excel. If I comment out my variable statement it works just fine...
My statement is in the first 2 lines and is"
Declare @EmployerCode varchar(10)
Set @EmployerCode = 'FCH'