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.

Since it is a windows 2000 standard edition, programs cannot allocate more than 2 gb.

To see how much ram sql server consumes, use the performance counters sql server provides.

The /3gb is missing.

What edition of windows 2000 server is it? Standard, advanced ...

Upper/lower case doesn't matter?

Is this only the first time or every time the query is run?

Oops, forgot to specify the field where the values should go into.

INSERT INTO #tmpFeatured (ListingID)  -- (Line 3)

SELECT ListingID from tblListings_Residential_Featured ORDER BY NewID()