Did you guys actually try my query??????

ddl = data definition langage. the script to create the table. If you could switch the clustered index to starttime, endtime, vehiculeid, starttime, endtime. That way you...

Hmm.. may I ask for the ddl of the tables.

Can you change the clustered index on the tables?

You can't create the system procs if they are already there... or maybe they are reserved in some way???

Anyways those system procs will recreate themselves when needed.

Use the script of the last version you saved somewhere an rerun it.

Otherwise you could do a restore of the db on another server, copy that code and replace the...

Well my first concern is making sure that the provided query can even use indexes. As it is written you'll get scans on any index (assuming you have the...

You run this query for every line of the main query??????? no wonder it's so slow.

WHERE (tblMerged.StartOdometer 0) AND (tblMerged.StopOdometer 0)

AND (tblMerged.StartTime >= @StartTime)

AND (tblMerged.StopTime <=...

I haven't seen any of those hit 100, but I agree that this is a odd one.

Close... it's the 5th thread I see hit 100. Maybe we should ask steve for a run down of the longest threads

Newbies take longer to understand... espicially with such a large code with asp 6.

Wanted to tell him that but that thread is opened 5 times/week so one less time shouldn't hurt anyone .

This is a code generating software I built a while back. It's tested and works perfectly, not to mention lightning fast, but the formatting is obviously multi line. ...

Forgot that one :

Set MyParam = SERVER.CREATEOBJECT ("ADODB.Parameter")

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null, CONSTRAINT Pk_Number PRIMARY KEY CLUSTERED (PkNumber))

GO

INSERT INTO dbo.Numbers (dude)

SELECT NULL...

Sure thing.. just make sure you actually do what I ask and you'll be fine .