Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jarryd (jarryd (AT) nodomain (DOT) com) writes:
If you are looking for entertainment, maybe you should be doing SQL
at all? :-)

I think the Query Editor is the best choice. While simple queries
lends themselves to graphic representation, more complex queries don't.
It may be boring to just select a query and run it, but somewhat naïvely
I assume that people who ask in these newsgroups are interested in their
professional development. But it's difficult to evolve as an SQL
programmer when you stay in the Query Designer.

And anyway, when you run a query in the query editor, you do get to see
the results.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

A bit of an elitist attitude you seem to have there Erland. I see the
smiley; it doesn't really do much to change that.

What's the big point you are making here? Don't use graphical tools to
create queries? At all? If you don't want to work towards being a human
coding machine then you shouldn't be allowed to retrieve data from a
database EVER. Instead, pay someone $1,000 a day to do it for you. Come
on. I don't do SQL statements all the time. I can get data out, create
functions, stored procedures, etc. Nothing too high-brow, but good enough
for what I need. Not doing it often and not being an accomplished typist I
find graphical aids helpful. Sure, doing more complex queries requires you
to get stuck in there, and I do on the rare occasion, butter fingers and
all. But often I am doing simple queries to check / fix up data integrity
issues. E.g. Navision is not displaying certain Sales Orders and some
simple querying reveals that this is because the Global Dimension fields are
blank and so these records have been filtered out. Rather than typing out:
USE NAVDB
GO

SELECT No_, [Sell-to Customer No_], [Posting Date], [Shortcut Dimension
1 Code], [Shortcut Dimension 2 Code]
FROM [Toray$Sales Header]
WHERE ([Posting Date] BETWEEN '20070401' AND '20080331')

I could simply right-click a table to open it, get rid of what I don't want
using the design pane and put in a few filters, and I'm there. I don't have
to run it four times to fix up typos. Brilliant!

We had something in SSMS2005 that worked better for me. It seems that has
been pulled for good reason as it tends to do things that are potentially
problematic. That is all you have to say. Having a go at my competency is
unwelcomed and more relevant to the purposes of these newsgroups, unhelpful.

Query Designer pretty much does what I need it to but I CANNOT run the query
from there. I have to click OK and run it from the query editor. It aint a
big deal, but why the extra step? Honestly, I don't see what Query Designer
without a results pane is doing better to stave off gremlins than having one
that does. There must be something and anyway, its gone. No problem, it
seems a little unnecessary but it saves on production costs for MS which may
or may not feed through to us customers, and ultimately I can manage without
it. I was only asking if there was a way to do things like we all used to.
The answer appears to be no and some reasons have been put forward that are
"fair enough", but making jibes offers little in the form of anything
constructive.

"If you haven't got anything nice to say, don't saying anything" is what my
dear old dad used to say ;-).

Regards,

Jarryd

A bit of an elitist attitude you seem to have there Erland. I see the
smiley; it doesn't really do much to change that.

What's the big point you are making here? Don't use graphical tools to
create queries? At all? If you don't want to work towards being a human
coding machine then you shouldn't be allowed to retrieve data from a
database EVER. Instead, pay someone $1,000 a day to do it for you. Come
on. I don't do SQL statements all the time. I can get data out, create
functions, stored procedures, etc. Nothing too high-brow, but good enough
for what I need. Not doing it often and not being an accomplished typist I
find graphical aids helpful. Sure, doing more complex queries requires you
to get stuck in there, and I do on the rare occasion, butter fingers and
all. But often I am doing simple queries to check / fix up data integrity
issues. E.g. Navision is not displaying certain Sales Orders and some
simple querying reveals that this is because the Global Dimension fields are
blank and so these records have been filtered out. Rather than typing out:
USE NAVDB
GO

SELECT No_, [Sell-to Customer No_], [Posting Date], [Shortcut Dimension
1 Code], [Shortcut Dimension 2 Code]
FROM [Toray$Sales Header]
WHERE ([Posting Date] BETWEEN '20070401' AND '20080331')

I could simply right-click a table to open it, get rid of what I don't want
using the design pane and put in a few filters, and I'm there. I don't have
to run it four times to fix up typos. Brilliant!

We had something in SSMS2005 that worked better for me. It seems that has
been pulled for good reason as it tends to do things that are potentially
problematic. That is all you have to say. Having a go at my competency is
unwelcomed and more relevant to the purposes of these newsgroups, unhelpful.

Query Designer pretty much does what I need it to but I CANNOT run the query
from there. I have to click OK and run it from the query editor. It aint a
big deal, but why the extra step? Honestly, I don't see what Query Designer
without a results pane is doing better to stave off gremlins than having one
that does. There must be something and anyway, its gone. No problem, it
seems a little unnecessary but it saves on production costs for MS which may
or may not feed through to us customers, and ultimately I can manage without
it. I was only asking if there was a way to do things like we all used to.
The answer appears to be no and some reasons have been put forward that are
"fair enough", but making jibes offers little in the form of anything
constructive.

"If you haven't got anything nice to say, don't saying anything" is what my
dear old dad used to say ;-).

Regards,

Jarryd

A bit of an elitist attitude you seem to have there Erland. I see the
smiley; it doesn't really do much to change that.

What's the big point you are making here? Don't use graphical tools to
create queries? At all? If you don't want to work towards being a human
coding machine then you shouldn't be allowed to retrieve data from a
database EVER. Instead, pay someone $1,000 a day to do it for you. Come
on. I don't do SQL statements all the time. I can get data out, create
functions, stored procedures, etc. Nothing too high-brow, but good enough
for what I need. Not doing it often and not being an accomplished typist I
find graphical aids helpful. Sure, doing more complex queries requires you
to get stuck in there, and I do on the rare occasion, butter fingers and
all. But often I am doing simple queries to check / fix up data integrity
issues. E.g. Navision is not displaying certain Sales Orders and some
simple querying reveals that this is because the Global Dimension fields are
blank and so these records have been filtered out. Rather than typing out:
USE NAVDB
GO

SELECT No_, [Sell-to Customer No_], [Posting Date], [Shortcut Dimension
1 Code], [Shortcut Dimension 2 Code]
FROM [Toray$Sales Header]
WHERE ([Posting Date] BETWEEN '20070401' AND '20080331')

I could simply right-click a table to open it, get rid of what I don't want
using the design pane and put in a few filters, and I'm there. I don't have
to run it four times to fix up typos. Brilliant!

We had something in SSMS2005 that worked better for me. It seems that has
been pulled for good reason as it tends to do things that are potentially
problematic. That is all you have to say. Having a go at my competency is
unwelcomed and more relevant to the purposes of these newsgroups, unhelpful.

Query Designer pretty much does what I need it to but I CANNOT run the query
from there. I have to click OK and run it from the query editor. It aint a
big deal, but why the extra step? Honestly, I don't see what Query Designer
without a results pane is doing better to stave off gremlins than having one
that does. There must be something and anyway, its gone. No problem, it
seems a little unnecessary but it saves on production costs for MS which may
or may not feed through to us customers, and ultimately I can manage without
it. I was only asking if there was a way to do things like we all used to.
The answer appears to be no and some reasons have been put forward that are
"fair enough", but making jibes offers little in the form of anything
constructive.

"If you haven't got anything nice to say, don't saying anything" is what my
dear old dad used to say ;-).

Regards,

Jarryd

A bit of an elitist attitude you seem to have there Erland. I see the
smiley; it doesn't really do much to change that.

What's the big point you are making here? Don't use graphical tools to
create queries? At all? If you don't want to work towards being a human
coding machine then you shouldn't be allowed to retrieve data from a
database EVER. Instead, pay someone $1,000 a day to do it for you. Come
on. I don't do SQL statements all the time. I can get data out, create
functions, stored procedures, etc. Nothing too high-brow, but good enough
for what I need. Not doing it often and not being an accomplished typist I
find graphical aids helpful. Sure, doing more complex queries requires you
to get stuck in there, and I do on the rare occasion, butter fingers and
all. But often I am doing simple queries to check / fix up data integrity
issues. E.g. Navision is not displaying certain Sales Orders and some
simple querying reveals that this is because the Global Dimension fields are
blank and so these records have been filtered out. Rather than typing out:
USE NAVDB
GO

SELECT No_, [Sell-to Customer No_], [Posting Date], [Shortcut Dimension
1 Code], [Shortcut Dimension 2 Code]
FROM [Toray$Sales Header]
WHERE ([Posting Date] BETWEEN '20070401' AND '20080331')

I could simply right-click a table to open it, get rid of what I don't want
using the design pane and put in a few filters, and I'm there. I don't have
to run it four times to fix up typos. Brilliant!

We had something in SSMS2005 that worked better for me. It seems that has
been pulled for good reason as it tends to do things that are potentially
problematic. That is all you have to say. Having a go at my competency is
unwelcomed and more relevant to the purposes of these newsgroups, unhelpful.

Query Designer pretty much does what I need it to but I CANNOT run the query
from there. I have to click OK and run it from the query editor. It aint a
big deal, but why the extra step? Honestly, I don't see what Query Designer
without a results pane is doing better to stave off gremlins than having one
that does. There must be something and anyway, its gone. No problem, it
seems a little unnecessary but it saves on production costs for MS which may
or may not feed through to us customers, and ultimately I can manage without
it. I was only asking if there was a way to do things like we all used to.
The answer appears to be no and some reasons have been put forward that are
"fair enough", but making jibes offers little in the form of anything
constructive.

"If you haven't got anything nice to say, don't saying anything" is what my
dear old dad used to say ;-).

Regards,

Jarryd