Re: SQL Queries Questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 02/01/05 

Date: Mon, 31 Jan 2005 22:11:43 -0500

"Seikyo" <Seikyo@discussions.microsoft.com> wrote in message
news:DD3C9813-E994-405D-AEBA-CE2BBB06D0F5@microsoft.com
> I suddenly found out the solution for the problem I post but I think
> is very lengthy.
> I use several SQL to do the stuff and Macro to link them I think.
>
> 1> I would update all the Hours by having [END_WORK] - [SCHD_START]
> (Both in time field)
>
> [END_WORK]-[SCHD_START]
>
> 2> I would filter those Queries with result more than zero so only the
> OverTime Hours will be found.
>
> [OT_HRS]-[BASE_HRS]>0
>
> 3> I would find those BASE_HRS>0 to deduct 1 Hours from the OT, only
> those OT >0 will be show
>
> BASE_HRS>0, [OT_HRS]-#1:00:00 AM#
>
> But now I do find some problem with my system. If I run the whole
> series of SQL , I will end up doing the record again and again. This
> will be a big trouble when the database get larger. Is there any way
> in which I can cut down on the search like an expression?

Almost certainly there is a simpler way to accomplish what you want ...
but I don't understand what it is that you want to accomplish. What you
say in this last message doesn't seem to fit with your original question
in this thread; maybe you have multiple discussion threads going at
once? If so, I don't know what you may have said in other threads.

I suggest you start with a description of the table or tables involved,
and then state what it is you want to do.. 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

Relevant Pages

  • Save various objects. Please, need advice ... Thanks
    ... LOCALIZED content in an SQL 2005 database. ... This content might be a string, an integer, a class, a control, ... ... What SQL 2005 datatype should I use to accomplish this? ... I am still a little bit confused of how to accomplish this. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Extrating Data from One Database from Another
    ... "Steve" wrote: ... > I am new to sql. ... > Both database contains last name, ... Here is what I am trying to accomplish. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Query
    ... What does the pound sign ... accomplish in sql? ... select * from tblYourTableHere ...
    (comp.databases.ms-access)
  • Re: Securing the MDF file
    ... Some folks have used EFS to accomplish this. ... both successfully, and with dismal failures. ... The successes where with ... With SQL 2005, there are many excellent internal encryption capabilities ...
    (microsoft.public.sqlserver.security)
  • Subqueries and Aggregate Functions
    ... I am having trouble coming up with the correct SQL to accomplish a ... Most of the SQL I use is quite simple and I rarely have to ... SUMFROM tblEntryActivity act WHERE ... ent.colEntryID = act.colEntryID)) AS [Indirect Service Time], ...
    (comp.databases.ms-sqlserver)