Re: SQL Server in SBS2000

From: Phil S. (nospam-m-phil-NoSpam_at_123.net)
Date: 06/03/04 

Date: Wed, 2 Jun 2004 20:30:08 -0400

Torrey:

BTW: What you want is a class of applications called CM (call management)
and / or CMR. I think one of the biggest seller is ACT! version 6. Many
others. Some require SQL backend. Trade off is Money upfront vs your own
database design.

Phil S.

"Torrey Lauer" <anonymous@discussions.microsoft.com> wrote in message
news:E2BE74CE-043E-4780-A6BE-F7BD32B46A12@microsoft.com...
> I would like to setup a database using SQL Server, but I don't even know
where to start. My terminology may be off a little since I've never used
SQL before.
>
> I would like to have several databases that also use forms. The first
database I'd like to create would be used for our outside agents (agents
that aren't in our main office). I'd like to have a place for our agents to
go within our existing agent's only site in order to search for a vendor by
name and/or click on a drop down bar to select the vendor. Once the vendor
is chosen, it would display information that I would have already populated
(ie: vendor's reservation number, vendor's website address, commission
levels that we are at with that particular vendor, and any other notes that
I would have listed for that vendor).
>
> Another database I'd like to have is one for call tracking. I don't know
if this would work for this type of senario, but what I would use it for is
for our agents to create a new "call tracking record" when they take a call.
This would tell us how many calls the agent is taking (ie: if we are able to
use reports to see how many call tracking records the agent created), who
they talked to on that call, what transpired on the call (ie: client wanted
a seven day cruise to the caribbean...wants to visit St. Thomas, St.
Marteen, etc. Two person are going, wants junior suite with balcony...I
quoted $1,500.00 including taxes, without airfare, per person...etc...).
That way, if that agent isn't in the office when that client calls back to
book the cruise or ask more question about the package the agent quoted, we
can pull that record up and read what the agent has already told that
client.
>
> So, I hope I got the idea across on what I'd like to do. Now, what I need
to know is, will SQL work for these senarios? What program do I use to
create the databases? Am I able to work right in SQL to set the databases
up, create the fields, populate the fields, etc...?
>
> I was thinking of using Access to do the call tracking, but I was thinking
that I'd like to have one place to have all this information.
>
> Can anyone provide me with some answers, some go to places to read about
SQL and how to use it, any books that would help me out? I've tried looking
at Microsoft's site about SQL and even did a google search for SQL, but
before I buy any reference books, etc. I'd like to find out some do's,
don't's, be carefuls, this works, that doesn't work, etc. from you guys.
>
> I appreciate any help any and/or direction any of you can provide me!
>
> Thanks!
>
> Torrey Lauer
> Modern Travel Services

Relevant Pages

  • Re: Poly Couples
    ... If you want to claim that OO is the consolution prize for lame database ... there is a metamodel which describes the hierarchy. ... Metamodel is stored in SQL, however, the data is stored in non ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: SQL questions
    ... SQL Server can handle this from the database side. ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.sqlserver.server)
  • Re: Poly Couples
    ... business software" example mentioned in this thread. ... But the communication mechanism with the database remains the same. ... That doesn't mean that other languages (such as sql, ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: SQL Server in SBS2000
    ... setting up SQL Server as the database backend is 'fairly' ... > vendor by name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
Loading