(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...

When the popup with the change script comes up, there is a checkbox automatically generate change script on save

This is a more complete version of

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql

-> http://support.microsoft.com/kb/839279

Either restricting their rights at database level to only allow selects and/or having a check on your query builder.

Do they connect to the database only by your application (application role,...

Freely translated from Access97 help:

The position of the new record depends on the type of Recordset:

If the type is dynaset, the new record is added at the end.

If the type...

If you omit the length of varchar, sql server picks the default length.

Normally it is around 30.

So CREATE PROCEDURE dbo.GET_USER_DETAIL (@lan_id varchar)

is actually like

CREATE PROCEDURE dbo.GET_USER_DETAIL (@lan_id varchar(30))

It bites

Surely you can speed it up this way.

To speed it further up, issue the proper sql statement instead of using .addnew, .update,.delete

This is a great site concerning does & don't...

select top 1 Result 

from @tmpResults

order by newid()?

One connection with multiple recordsets

according to

http://www.eruditesys.com/web-design-articles/optimizing-php-and-asp-code.html

*does  GetSubjectLine(strReport) returns unicode?

*Is Access Module Time a datetime field?

If you create a test stored procedure

CREATE PROCEDURE [dbo].[get_phy_list]

 @DateFrom datetime,

 @DateTo datetime,

 @mName varchar(50) =null

AS

SET NOCOUNT ON

SET @moduleName  ='Part I'

SELECT...

some comments

*replace

and dbo.[Doctor Module Log].[Module Name] ='+ @moduleName ' 

with

and dbo.[Doctor Module Log].[Module Name] =@moduleName

*SELECT  *  from   dbo.TrainingName     

Don't use select *, name...