I have just put print boy in the loop for testing purposes, I intend to have some statements on it.

But now that I have the loop working, the foundation has...

Hi Jeff

Thanks for your interest.

Yes, the format of termination_date is YYMMDD

Also, I have had to join on the table itself because, I dont want to insert whats already been inserted...

The problem is that '20060801' equates to the current date, so its nto a constant.

Also the query is a dynamic one.could be '20060729' can either be forwards or backwards

Thanks all, your help really appreciated.

with what Tom said, I will avoid comparing integers to varchars, especially in a loop.

Thanks

John

Hi

Thanks for reply, tried doing that, still no joy.

Thanks in advance

Cheers mate.

I will come up with a doc shortly

Thanks for your earlier post.

Can someone confirm the following,

1. I can't create indexed views using SQL standard edition.
2. In my situation, since the tables are created daily, my only option is...

Thanks everyone for replying.

Please let me know exactly what you need ?

Sorry what do you mean by 3GB switch, do you mean that changing the boot.ini file to allow applications use max of 3GB or RAM.

Buffer Cache Hit ratio is around...

Thanks for your post Mark,

Its true that I dont want duplicates geting into the table, but the thing is that the insert goes straight to the temp table, so leaves...

My server hasnt got 4GB RAM on it, so I can I make SQL server use more than 1.7GB.

Your solution is under the assumption that my box has 4GB of...

Didnt quite understand your last post, can you be a bit more clearer please. Are you saying its meant to be using 3GB or memory or would get stuck at...

There was a Clustered Primary key index on the table, is this a good or a bad thing ?

Performance booster or Killer ?

My DB's are quite huge, around 1.8 Terrabytes across a whole box with one database with an average size of 800GB.

SQL server memory stats are as follows:

CPU TIMe: 166

MEmory usage:...

Here is the code, I dont understand what needs to be tuned:

Please note that MedicRecs has 90millon rows 

select Sum(MED.ConsultTime) as CallDuration,