assuming access97

dim rs as dao.recordset

dim sqlstring as string

sqlstring="SELECT clinicianid from qryPatientCheck where ClinicianID= " & Me.ClinicianID.Value

set rs=currentdb.openrecordset (sqlstring)

if rs.recordcount>0 then

'found

else 'not found

end if

rs.close

set rs=nothing

Just a note

It assumes that FirstTreatment is always later than AssesmentDate.

Datediff is indeed more appropriate.

When you install sql server 2000 on a windows 2003 machine

ignore the warning that servicepack 3 is required.

Install sql server 2000, install servicepack 3 or higher. (otherwise 2003 only allows connections...

what about

v=year([FirstTreatment])

w=year([AssesmentDate])

TimeOnWaitingList: ([x]-[y])+((v-w)*12)

from sqlserver to oracle:

http://support.microsoft.com/default.aspx?scid=kb;en-us;280106

basically:

The same problem was in a thread only a week old. I'll see if I can find it

*can you specify with nolock for

SELECT .....

FROM master.dbo.sysprocesses WHERE hostname=host_name()

we don't want locking to occur in system tables

*for CREATE  TRIGGER Via_Peticiones_TI ON dbo.Via_Peticiones

FOR INSERT

AS

specify SET NOCOUNT ON

The Oracle installation fiddles with the registry.

Perhaps just a restart of sql server service will do.

I've allways rebooted  the machines after the installation of Oracle 8 just to be sure the...

in .NET you could make a filewatcher that reads the txt,execute

a stored proc with parameter idcard, amount,...

which checks validity & does the transaction when necessary

and returns the result to...

Hello,

Do you have some info on the sql server version,service pack & hotfixes?

*found this whilst browsing the internet, not sure if it applies

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B827448

Sql server is greedy on memory but releases it when other applications need it.

Usually it starts with a "low" memory usage because it hasn't stored execution plans etc in cache....

Have you rebooted the machines?

1 day and 1 hour = 25 hours

Do you have sample data and the wished outcome?

Because if for an odd reason the order of the parameters change (similiar with the order of columns in a table), the call will still work.

procedure myproc @startdate,@numberofdays

-> procedure myproc @numberofdays,@startdate

EXECUTE...

The user isn't system administrator or db_owner?