P
Philip Rupp
I'm wondering if any work is being done to improve support for SQL in Excel
and MSQRY. It's clear that Microsoft is positioning Excel as its premier
data query/analysis tool (ie the upcoming PowerPivot tool) ... and yet MSQRY
is grossly lacking in its ability to express and render complex queries in
the GUI. From what I'm seeing, MSQRY is getting a new version number with
every Excel version release, but nothing is ever really changing, and hasn't
for some time now.
MSQRY needs to have full support for complex join scenarios ... and should
give the user design support to express them. The query designer in SQL
Server Mgmt Studio is able to! Why not pull this functionality into MSQRY
and make some real headway in this area.
I took a brief look at PowerPivot and this capability doesn't appear to be
present in this new offering either.
My only recourse has been to create these complex queries in SSMS and then
paste the SQL statement into MSQRY or create a view in the database.
Frankly, this is nonsense ... and this doesn't enable my data savvy staffers
to "self service" their data needs ... which has been another hot topic
coming out of Microsoft lately related to Office & Excel.
I acknowledge that I don't know "all there is to know" about Excel . so I
may be missing something and I'm open to tips and pointers that will help.
But if I'm on target . then COME ON GUYS!
Get it together!!!!
and MSQRY. It's clear that Microsoft is positioning Excel as its premier
data query/analysis tool (ie the upcoming PowerPivot tool) ... and yet MSQRY
is grossly lacking in its ability to express and render complex queries in
the GUI. From what I'm seeing, MSQRY is getting a new version number with
every Excel version release, but nothing is ever really changing, and hasn't
for some time now.
MSQRY needs to have full support for complex join scenarios ... and should
give the user design support to express them. The query designer in SQL
Server Mgmt Studio is able to! Why not pull this functionality into MSQRY
and make some real headway in this area.
I took a brief look at PowerPivot and this capability doesn't appear to be
present in this new offering either.
My only recourse has been to create these complex queries in SSMS and then
paste the SQL statement into MSQRY or create a view in the database.
Frankly, this is nonsense ... and this doesn't enable my data savvy staffers
to "self service" their data needs ... which has been another hot topic
coming out of Microsoft lately related to Office & Excel.
I acknowledge that I don't know "all there is to know" about Excel . so I
may be missing something and I'm open to tips and pointers that will help.
But if I'm on target . then COME ON GUYS!
Get it together!!!!