RE: Cheap SQL application

Subject: RE: Cheap SQL application
From: John Posada <JPosada -at- book -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Mon, 10 Feb 2003 11:34:36 -0500


Hi, guys...in the event that anyone is interested in how I finally addressed
this need...

I used Excel. I created a table with somewhere around 12 columns and right
now, about 5,300 rows, though I'm getting ready to add another category
which could multiply this by a factor of 10 or more (right now I list about
100 databases...I'm getting ready to add the tables for each database.

Excel has a nifty feature called Autofilter (Data -> Filter -> Autofilter).
With this, I can select, from a pull-down list, a specific value which will
result in showing a subset of the table. I can then select remaining values
from any of the other columns' pulldown lists to further refine my query. I
can also create custom criteria including most of the common Boolean
qualifiers (includes, not includes, >, <, ends with, begins with, etc)

If used intelligently, it can be pretty powerful. I can used this autofilter
ability to reduce the list of 5300 elements to an exact result of 5-10 or so
records. In fact, everything I can do with a query select statement, I can
do with autofilter.

John Posada
Senior Technical Writer
Barnes&Noble.com
jposada -at- book -dot- com
NY: 212-414-6656
Dayton: 732-438-3372


==========

Hi, guys....before I hit my company up for a seat on their Microsoft SQL
Server 7 Enterprise, is there a cheap (we might be talking about my
money) SQL application that I could load locally on Win2000 for doing
simple queries?

I'm accumulating a database of physical/virtual/cluster machine names,
databases names, MSMQ names, database tables, stored procedures, ODBCs,
IP addresses, etc., that I need to present in different views where I
could extract the information that I need in the sequence that I need it
for inclusion into documentation.

An example might be:

SELECT MSMQ, physical_server, virtual_server
FROM Servers
WHERE SystemDomain = H
ORDER By MSMQ, physical_server;

You get the idea. Anyone?

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Buy or upgrade to RoboHelp X3 today and receive the WebHelp
Merge Module for FREE ($299 value). RoboHelp X3's all-new
features include conditional text, completely re-engineered
printed documentation output, Context-sensitive Help Toolkit,
single-source layouts, and more!
Order online today at http://www.ehelp.com/techwr-l


---
You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit
http://www.raycomm.com/techwhirl/ for more resources and info.



Previous by Author: RE: but is thinking required also?
Next by Author: RE: Great web site!
Previous by Thread: RE: Disclaimer or urban legend?
Next by Thread: Please disregard: Bullets missing from PDF


What this post helpful? Share it with friends and colleagues:


Sponsored Ads