because the alias has a dot in the name

CASERVICEDESK.ctct AS CASERVICEDESK.ctct_1 ON CASERVICEDESK.call_req.customer = CASERVICEDESK.ctct_1.id

->

CASERVICEDESK.ctct AS ctct_1 ON CASERVICEDESK.call_req.customer = ctct_1.id

have you checked the jobschedule status with

sp_help_jobschedule ?

Have you checked the table for corruption?

You can circumvent it with

DECLARE  @var1 datetime

SET @var1 =CONVERT(DATETIME, SUBSTRING(CAST(GETDATE() AS CHAR(20)), 1, 12), 103)

EXECUTE  u_GetWeekNo @myvar=@var1,@week OUTPUT

CREATE PROCEDURE TimeSheet

(

@company_name varchar(50) = '%',

@employee_name varchar(50)= '%',

@work_no varchar(50)= '%',

@work_type varchar(50)= '%',

@time_type varchar(50)= '%',

@work_date1 datetime = NULL,

@work_date2 datetime = NULL,

@date_operator as varchar(2000) = '='

)

AS

SET NOCOUNT ON /*skip a roundtrip*/

IF (@work_date1...

sp_helplogins

Sure they aren't accessing the tables directly instead of using the view?

Cross database ownership enabled?

*DROP TOP 100 PERCENT

*I've rewritten it a bit. Check if the outcome is the same.

SELECT

 dbo.tblOrganization.OrganizationTitle AS Organizatie

, dbo.tblInstallation.InstallationTitle AS Instalatie

, dbo.tblForm.FormTitle AS Formular

, dbo.tblParam.ParamTitle + '[' + ISNULL(dbo.tblValue.MeasUnit, '')...

Have you declared all sizes in your stored procedure?

Like convert(varchar(mylength),my variable) instead of convert(varchar, myvariable)?

if you know the maximum length of the column

select myfield

from mytable

order by convert(char(maxlen),myfield)

all those brackets are confusing me

but the subselect in ON=

LEFT JOIN    [SELECT description, id, type, call_req_id, last_mod_dt FROM act_log] ON call_req.persid = [SELECT description,id,type,call_req_id,last_mod_dt].call_req_id) 

looks like a weird construction

There is an article about it:

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

from the books online

The changes specified in ALTER TABLE are implemented immediately. If the changes require modifications of the rows in the table, ALTER TABLE updates the rows. ALTER TABLE...

There could be too many statistics.

sp_helpstats shows the statistics on the table.

(n)textfields or (var)char fields?

If varchar you can write an user defined function

Either with the function ASCII (returns int value of the first character)

or with calling REPLACE  x times.