To be honest - i can't think of a way to do this

in the past when writing bespoke apps i have created a view that runs along the lines of...

i've also found that importing to Access first and then to SQL improves the process.

et voila.

my logo and hyperlink!!

That's correct. if you want a field to not allow duplicates (that isn't the entire primary key) then you need a contraint.

if you are in the UK...

antares is right.

what happens if more than one person have the page open, do they all process the data?

how about using the page to append to a Holding table...

True.

Just waiting to sort out all the other stuff as well (like a company logo etc...)

just for you i'll sort it out today!

or did you mena that the transaction log becomes fuill because of the amount of data that you are manipulating? if so switch to SIMPLE recovery mode and checkpoint the...

you've obviously got to keep the data until you have migrated it into the new table.

you should still keep your invoice table with the fields invoice_no,invoice type

then how about...

where did you decalare the @counter variable used in the following? unless i'm being really stupid here.

update STable

set counter = @counter,

@counter = @counter + 1

where sid=@sid

and STypeID=@STypeID

have you also...

I've always found that the best method is nearly always to PULL the data to the detination rather than PUSH it from the source.

with that in mind the Access import/link...

the problem here is that you have placed an auto number in the companies table and defined it as the primary key.

a primary key is defined as the entity that...

if you want to keep up with the latest service pack versions download the micorosft baseline security analyser.

it's free and will tell you all hotfixes and service packs that are...

out of interest is it quicker?

all you are doing here is replicating what the SQL server is doing....

if you are using ADO.net then you can send the query and return a recordset.

the ado recordset...

this should help

select xys from mytable where datepart(dd,mytable.datefield)=datepart(dd,getdate()) and datepart(mm,mytable.datefield)=datepart(mm,getdate())

Cheers