[AccessD] SQL List

Karen Feller Nicholson ksfeller at earthlink.net
Sat May 17 13:01:59 CDT 2003


MessageWell 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 
  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: 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


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030517/39700f0b/attachment-0001.html>


More information about the AccessD mailing list