Arthur Fuller
artful at rogers.com
Mon May 19 07:23:11 CDT 2003
I played with your problem and came up with a "solution", but then re-read your note and discovered that I had missed part of the problem. The phrase "grouping sort" confuses me. Do you mean something like this: PK FK YourColumn 1 1 10 2 1 20 3 2 10 4 2 20 5 3 10 6 1 40 If so, you're right, it is a little tricky. In the sample above, you need to find the largest value in YourColumn where the FK is equal to the FK you are inserting. Is that what you need? Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Karen Feller Nicholson Sent: May 17, 2003 2:02 PM 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, <mailto:CWortz at tea.state.tx.us> 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 <mailto:ksfeller at earthlink.net> 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/20030519/9f628a2c/attachment-0001.html>