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.

Try

You need to check the configuration for the service. Go to

Services(from Control Panel or Administrative Tools -

depending on your OS).

Go to the sqlserveragent service and view the properties for

the...

*rewritten with joins

*group by takes care of distinct

SELECT B.BookingID,

ISNULL(UPPER(C.CustomerSurname),'') AS CustomerSurname

FROM tbl_hp_bookings B WITH (NOLOCK)

INNER JOIN tbl_hp_bookings_transactions BT WITH (NOLOCK)

 ON B.BookingID = BT.BookingID

 AND BT.TransactionTypeID <> 1001

LEFT JOIN tbl_hp_customers C WITH...

*convert the int properly with convert(varchar(length_of_field),code)

*another way of updating

UPDATE OccRadiology

SET OccRadiology.Ipsil= goodcodes.code

FROM OccRadiology

INNER JOIN /*only the ones who match*/

(select convert(varchar(30),CodeLookUp.Code) as code /*ipsil is varchar*/

FROM CodeLookUp

WHERE CodeLookUp.CType = 93

) AS...

That's odd.

How do you start sql server agent? From services.msc ?

What sql server version are you using?

Does the path in services.msc ->services-> SQLSERVERAGENT path to executable is correct?

Mine is sql...