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

*Using dates in the format mm/dd/yyyy is generally not recommended.

What is 01/10/2006 the first of october or the tenth of january?

With 20060110 (yyyymmdd) there is no doubt and also is excellent for...

Does the servicepack of the client tools matches the one of the sql server?

Welcome back.

Try the sample at http://support.microsoft.com/kb/q194792/.

Apparently there must be a recordset in order to capture the returncode.