Try

SELECT      empper.first_name,

                empper.last_name,

                empper.middle_name,

                empper.birth_date,

                empper.sex,

                empper.pers_status,

                empper.company,                        

                empbplan.elig_code,

                empbplan.bplan_code

FROM    empper

            LEFT OUTER JOIN

            empbplan

            ON empper.emp_id = empbplan.emp_id

          ...

I used #temp_output as my table to test my sql.  Hopefully this will help. 

create table #temp_output

(id integer,

 jan varchar(1),

 feb varchar(1),

 mar varchar(1),

 apr varchar(1),

 may varchar(1),

 jun varchar(1),

 jul varchar(1)

)

select id, SUM (CASE when Jan...

Jonathan,

    when I do the activex script, it looks like it is fine until a NULL value is encountered then I get errors about the paramters to the CSTR...

In the Access I meant the datatype of the columns are date/time

Thanks for the input

Better to give an example

create procedure usp_rpt_list

as

BEGIN

create table #output

(id integer,

id_desc varchar(10),

active integer

)

insert into #output (id, id_desc)

select id, id_desc from tableA

...Logic to set active column

SELECT id, id_desc, active from...

I don't think you can use the getdate function like that it needs to be in a SELECT or WHERE clause. You can call your funtion like this

DECLARE @curr_date...

We have both install on the same machine(Test Area) with no problems? One note is if you decide to uninstall SQL Anywhere it does utilize some ODBC dll's...

Thanks, That is what I did and I'm back up and running

We do auditing on our Remote Users in a replicated environment. So the triggers only fire when the replication process is doing the inserts/updates. This is done in...

Thanks for the reply

It is using an account that was working before deployment. I have just notice when the deployment team installed the computer at our remote site, the computer isn't part...

We try that and it still didn't help. We finally had to update the sysdatabases table to say it wasn't involved with replication and then we were finally able...

Thank you that worked.