maybe just perform the select so you can detect and verify the duplicates

How about avoiding the udf and using this select ?

SELECT rs.EmployeeID, rs.School, w.WorkDate

, isnull((select max([counter]) + 1

FROM SchoolServices

WHERE EmployeeID = rs.EmployeeID AND School = rs.School AND ServiceDate = w.WorkDate...

sorry for the delay.... been out for the long weekend

Like Bob Monahon replied : this query...

just to add ..

you can use Alter view . BOL : Alters a previously created view (created by executing CREATE VIEW), including indexed views, without affecting dependent stored procedures or...

- tripple join

or

where with exists-clause for each condition

e.g.

select *

from myself T1

where exists (select * from myself where id = T1.Userid and...

AFAIK this is not possible with sqlserver, unless you use partitioned views. i.e. create a table per partition, manage each table's indexes according to the specific tables needs and create...

this what I use with VB6 sqldmo :

I hope this can help sort things out

Private Sub ScriptJobs()

    On Error GoTo ErrorHandler

    strStatementId...

just my 2 ct

- Why use a count(*) if your functionality is 'if exists '

- case yourcol when 0 then ...

                     else yourcol

                     end

are you member of the sysadm-sqlserver-role on the instance where it fails ?

DECLARE @MaximumDate  char(8) ?? Why not use smalldatetime ??

Is MaximumDate in the table/view also defined char ?? if yes,you'll have to take care of it's format...

We use this T_TableLoadData in a way that we record if data is being loaded (loading_bit = true) and all applications querying the data will use a view which has an...

truncate clears the whole table and frees the pages in use by the table.

Delete is a logged operation and can have conditions. pages in use by the table are freed...

It will be more interesting when :

1) make your timestamp_last_update a datetime column !

2) always update the last_update_error (make it INT)

set @SQL_Error = @@error

if @SQL_Error = 0

begin

update T_TableLoadData

    set...

if you are not using a where clause , you could use "truncate". see BOL

Try to perform many small chunks of transactional deletes to avoid blocking.

SET ROWCOUNT 1000

declare @Nrows int

set...

- doesn't Lotus Enterprise Integrator  have any error-reporting feature ??

- you could create a parameter-data containing Table_name and timestamp_last_update and then add as last statement of each table-handling block :

 update...