haven't checked this but it should work.

select i.itemno, i.price, i.valid_from, i.valid_to, r.rebate

from items i

inner join supplier_rebate r on (i.supplier_id=r.supplier_id)

where (r.rebate_valid_to between i.valid_from and i.valid_to)

hope this helps

There is a great article here http://www.sql-server-performance.com/sql_server_configuration_settings.asp whihc should get you going - the site it is on is a great source of info relaing to optimisation of many aspects...

I think the only benefit of using 2 processors that I can think of at present would be that you would be able to use a processor for sql exclusively...

You could try having a look at SQL

Go here !

http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318

going to google and searching for 'shrinking sql server transaction log' would be a good start

or you could go here http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318

no - i would just import them straight into your database.

(right click on database > ALl Tasks > Import Data > set datasource to text file)

i'm digging myself a hole here !

i added a post advising you to try @@rowcount inside the function, not realising you did the insert in the SP - went in...

it can't do any harm if it is out of hours - i used to do all databases over night

ignore the post above - doh!

AFAIK sql server is pretty good at keeping statistics relating to indexes etc. There is a wealth of information relating to the optimisation of sql server in various places (BOL,...

Unbelivable.

I stand astonished.

That must be, though, the worst way of entering data into a table ...

I tested it before i replied to your first post with no problems.

Unless I'm missing something here ?

I used this:

create table test3([id] int not null, value varchar(50))

insert into test3 values(1,...

<snip>

Hate to ask this but does the table have a PRIMARY KEY??

IF the table doesn't it will be READ-ONLY through QA.

Let me know.

Thanks,

AJ

</snip>

Are you sure this is the...

Indeed that is what I meant.

Thanks for correcting me.