View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Russ[_6_] Russ[_6_] is offline
external usenet poster
 
Posts: 1
Default SQL Statement Attaching to SQL Server

I have a SQL statement that runs perfectly in SQL Server's
Query Analyzer (includes a COMPUTE ... BY statement). When
I run it in Query Analyzer it works, when I run it in
Excel's Microsoft Query box, it only returns the first
group and doesn't do a compute. Is there a limitation to
the extended SQL that I can use within Excel?

Thanks