Not enough details... sample data and required results please??

Another proof that it's not always a good idea to blindly believe what everyone's telling you. What level was it set on?

Did I tell you about the years I was...

No I meant your company, assumed you worked in part for a school. Anyways I don't know about the adovbs.inc hint. But as long as it works just use...

Stupid, direct, obvious question here... How am I supposed to know what you want the sp to return if you show me explicitly what you need?

Read this so that...

This is vba code. You need to do small translation to make it work in asp.

If you use the include file I provided, the single modification missing should be...

Didn't you tell us that it was not the problem??

SET NOCOUNT ON is to tell the server not to send the messages x row(s) affected.

Select @@Error is to save the last error number because it is reset after every...

You may change this to not use the function and directly pass the correct values to the parameters.

You will need to change the Declare as ADODB.* to server.createObject("ADODB.*")

you will also...

SP :

create procedure dbo.sp_biginsert

@SRrequestDate varchar(50),

@SRschoolNameFirst varchar(150),

@SRschoolNameLast varchar(150),

@SRschoolCompany varchar(150),

@SRschoolBranch varchar(150),

@SRschoolAddress1 varchar(150),

@SRschoolAddress2 varchar(150),

@SRschoolCity varchar(150),

@SRschoolState char(10),

@SRschoolZip varchar(20),

@SRschoolPhone varchar(35),

@SRschoolFax varchar(35),

@SRschoolEmail varchar(50),

@SRschoolRegion varchar(75),

@SRschoolSupervisor varchar(75),

@SRschoolclaimType varchar(50),

@SRschoolDateOfLoss varchar(50),

@SRschoolInsured varchar(50),

@SRschoolClaimNumber varchar(50),

@SRschoolPackaging varchar(50),

@SRschoolContactPrefs varchar(50),

@SRclaimantNameFirst varchar(150),

@SRclaimantNameMiddle varchar(150),

@SRclaimantNameLast varchar(150),

@SRclaimantOffice varchar(150),

@SRclaimantAddress1...

k. can you give data samples, the parameters for the where conditions and the expected results?

Wow, thanx for the tip. Here's the corrected version and results :

create database test

use test

exec sp_dbcmptlevel 'Test', 80

GO

exec sp_dbcmptlevel 'Test'

Select top 10 * from dbo.SysObjects

--no error given

exec sp_dbcmptlevel...

Here's the correct solution :

Select Whatever from dbo.Table where DateCol between @DateStart and @DateEnd.

Can you remerge the month/year columns into a smalldatetime column?

Thanx for the x rows at the time version... didn't want to write a 2nd versions .

Why would you want to rename the views??

You can name the indexes whater you want.

Or you could always do this, but it would be 3 to 5 times slower :

NUM1 in (@1, @2, @3, @4, @5) AND

NUM2 in (@1, @2, @3, @4, @5)...