SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Building Joins the Easy Way


Building Joins the Easy Way

Author
Message
Dale Corey
Dale Corey
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1601 Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dcorey/bu


All the best,

Dale

Author:
An Introduction to SQL Server 2005 Management Studio
jimryan
jimryan
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 1

sheeeez, I've been using sqlserver for about 5 years now and didn't know all those options were on the menus!

tks





Vincent Rainardi
Vincent Rainardi
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 1

Same like JimRyan, I've been using SQL server for 3-4 years but I didn't know that this facility was there. I used that facility in Access.

Thanks to Dale. Regards, Vincent


Dale Corey
Dale Corey
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1601 Visits: 4

You folks are perfectly welcome! Sorry about Figure 10. I told Andy and Steve about it missing but I don't think they got to it before the article was published. It's basically a print screen of the SELECT query as it appears in Query Analyzer.

Good luck to everyone who chooses to try query building with Enterprise Manager!

Sincerely,

Dale




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Santosh Kadam
Santosh Kadam
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 1

Thanx Dale for your article and the information you threw light on. I was developing reports for my system which involved lot of big and complex sql scripts involving six to seven tables and i used to write the query which was really time consuming. Through this way i believe that it will really help me to save my time.


Benjamin S Taylor
Benjamin S Taylor
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 1

Dale,

Thanks for taking the time to write a good article. I especially appreciate the screen shots.

A couple questions:

1) Where would you recommend a person go for assistance when the graphical tools are not sufficient?

2) What do you use for optimizations that are not provided in the graphical tools?

3) Why not use views for the type of problems you are presenting in your article. If the primary benefit from the graphical query painter is to provide join and filtering then this kind of work can be done effectively in a view once and used by all users who do not need to have effecient queries.

In short; it appears that your audience is for people to write SQL without knowing how to write SQL. A good DBA will have this already done for those who do not know how to write SQL through Views, User Defined Functions that return tables or Stored Procedures.

Still, I will be passing along your article to co-workers as it represents a lot of questions I answer frequently (sound like a contradiction) because I don't have enough time to do everything ahead of time.

Keep the tips coming.


Ben


Dale Corey
Dale Corey
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1601 Visits: 4

Benjamin,

I would recommend using templates and/or scripts (Object Browser) in Query Analyzer.

BTW, I have to write queries that involve many tables/joins. I use QBE in Enterprise Manager to help me along with the most complex ones. It really makes it a lot easier. If you've never tried it, you should. It's very cool.




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
williamhoos@yahoo.com
williamhoos@yahoo.com
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 1
One additional comment on this process. I still find the query tools in EM awkward and wanted to make sure people know that you can follow the same process in this article, but using an Access Project to create views, procs and functions in SQL Server. The interface is almost identical to the options in Access databases and has some features missing or awkward to use in EM. Just a thought.



David Catherman
David Catherman
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 1

Thanks for the article. I too struggled with the options. I even created an access project for the SQL database and continued to use Access as much as possible. But It forced me to save every query before executing creating a mess of temp queries.

An even better option is to use the query generator in Visual Studio. Create a Database Project and keep all your stored procedures and queries there (allows source contorl). When you open the TSQL code file, you can highlight portions and right-click to build the Query visually. This is a much better tool, but does not show the output as well as Query Analyzer.

VS2005 has even a better tool.

Dave C.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search