[AccessD] SQL List

Karen,

So you are talking about SQLServer.  Then the best list is our own
dba-SQLServer list.  You will learn about SQLServer, T-SQL and Crystal
Reports all on this one list.  You can sign up for it at the same place
you signed up for AccessD.  I expect to see you on that list very
shortly.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Karen Feller Nicholson [mailto:ksfeller at earthlink.net] 
Sent: Saturday 2003 May 17 13:02
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL List

 
 Well Well.  Let me confess to what I have done THIS time.  Years ago I
started out as a contract Access programmer and had never touched
Access.  Now I went and got myself hired at this great company as
Database Administrator for SQL and a Crystal Programmer.  Oh my.  I
started Friday; they interviewed me Tuesday afternoon and called me
Thursday afternoon to start.  They know I am not that proficient in SQL
and Crystal, but they seemed more interested in my personality than my
job skills.  So there is this SQL program already written, MasterMind,
that I have to write triggers and stored procedures, creating these for
various departments to write reports.  I got tired of consulting after 8
years - too much going on at once and then waiting for cheap ***'s to
pay us.  So I walked out and left my poor partner here WILD EYED as he
now has enough work for 1.5 Access programmers and is only one person.
I got an earful when I came home Friday night.  My first project thrown
at me was to add a column to a table that increments values by 10,
renumerating when the grouping sort changes.  Figured that would be easy
- ha ha.  I am delving into the cursor crap, did the increment value in
the table itself but it does not know when to start back again at 10.
That is my current dilemma.  I am sure that I will catch on, but I am
sure to be a pain in the bum for a month or two until I get my feet
under me.  Anybody ever work with MasterMind which I have nicked named
MasterBa*** at this point.  Fun fun.  All help is appreciated.  And
anyone who can calm Mike down with his new found too much work scenario
as well.  He smoked two packs of cigarettes my first day on the job!!!!
----- Original Message ----- 
From: Wortz, Charles 
To: accessd at databaseadvisors.com 
Sent: Saturday, May 17, 2003 01:03 PM
Subject: RE: [AccessD] SQL List


Karen,

As you see from the list Dave gives you, there are many flavors of SQL.
Which flavor are you most interested in? M$'s Jet SQL for the Jet db
engine, or M$'s T-SQL for the SQL Server engine, or ANSI SQL that
everybody claims to be compliant with but does not fully implement?
Charles Wortz 
-----Original Message-----
From: dave sharpe [mailto:davesharpe2 at cox.net] 
Sent: Saturday 2003 May 17 11:29
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL List


Karen

http://groups.yahoo.com/

Has a "SQL_beginners" list

Do a search there. They have over 500 SQL related groups.

Dave
----- Original Message ----- 
From: Karen Feller Nicholson 
To: AccessD at databaseadvisors.com 
Sent: Saturday, May 17, 2003 8:58 AM
Subject: [AccessD] SQL List


Does anyone belong to an SQL list similiar to this Access List that they
recommend?  
Karen S. Nicholson
(724) 942-3437
ksfeller at earthlink.net