'Simplest" way is to use the windows scheduler on a suitable machine-it that mean the suitable machine need to be on all the time. 

Second trick is to create a "master" database...

I used sql 2000. While I debuged, I used print out the sql statement, so I know what is wrong with that.

CREATE                   PROCEDURE dbo.CCPercent

@quiz VARCHAR( 25 )=null,

@cc  ...

I create the database with the same name and copy the back up file from the  development machines and restore that in the hosted service provider. and delete all the test data...

Thax. that is what I want.

I think I need to define the dbo.f_reuParseList something like that here. Thanks.

                             dbo.f_reuParseList(@cc, ',') lt

                                   WHERE lt.ListItem = o.JObCCNO)

I got lost; I tried to modifed the stored procedure I have add some criteria.

I do not know how to accomplish that. the blue part is what I do not...

Thanks. I tested. it work fine. but what select 1 here mean. 

select o.EMPLNO ,[FULL NAME] , [Unit],[Unit Desc],Manager, Department, JobCCNo

from dbo.OcchEmp o

where exists (select 1 from tblPreviousWinTrainingLog ...

Thx.

Here is my sp according to the posting.

ALTER                 PROCEDURE dbo.CCPercent

@quiz VARCHAR( 25 )=null,

@cc   nvarchar(125) = NULL,

@debug     bit          = 0

as

DECLARE @sql        nvarchar(4000)   

begin                                                                  

set

thx. It is much clear version. but if i want to group by quizname. how can I accomplish that ?

for me , it seems they only request incompleted count. total employee-completed empl count. it will be incompleted count. if they do not have the training record in the log....

if they have training date. they have the record on the log. then mean they have training.

I have employee table which contain the cost center and employee training log. some employee take the training multiple time.

I need to get the percentage of training for the cost...

I tried to copy the log file to other location and look at the log file to better understand the active and inactive concept. it gave me error for sharing violation since...

you are right. I gave up. I just used stored procedure. it work. thx.

then , how to fix ? Thx.: