Hi,

That seems quite a lot of customers to be presenting on a single web page, even in a number of drop-downs.

Have you thought of putting in a filter mechanism i.e....

Hi,

The NOT FOR REPLICATION was indeed the problem.

Thanks again for your input.

Graeme

Hi,

Without knowing the frequency of importing your options are varied.

A DTS package works very well to import the raw data into a 'staging table'. You can even 'clean' the data...

Joe,David,

Thanks for that.

Is it wise to disconnect the server from the network whilst applying the patch?

I have read that there may be issues when the server is put into single...

Hi,

Is there any reason why they can't view the data in query analyser?

I'm probably stating the obvious but can't you control access to the data with a typical SQL security...

Hi,

I think it is good practice to have a 'staging' area (if you like) to house your site and database. You can afford to try a lot more changes without...

Jonathan,

That worked a treat..many thanks. I neat solution. Although the cursor solution runs a lot faster.

Still, it's not run too often.

Thanks again

Graeme

Many thanks for your input guys.

Calvin you are right it still only returns 10 rows.

Jonathan, that is the sort of thing I am after, I will try to apply that...

Russel thanks for that.

That still only returns 10 records.

My routine returns 10 records per staffindex. So if my select distinct staffindex statement returns 10 rows, I should end up with...

Hi,

I do quite a bit of this sort of thing.

All I do is keep it very simple.

I design all my forms from scratch using ASP and HTML, using a basic...

C'mon guys, get real.

I think we are all big enough and PROFESSIONAL enough to know the correct answer to this straight forward question.

Granted, some QOD are open enough to offer...

Mmmmm....I have to agree.

Unless there are severe performance issues resulting from poor design, I can't see any reason for doing this.

I'd put money on the scenario where, having completed your...

Hello again,

Well everything pointed to permission issues and it turns out to be a permission on a table.

Thanks again

Graeme

Here's the code that connects to the database

Const DTSSQLStgFlag_Default = 0

Const DTSStepExecResult_Failure = 1

Dim oPkg, oStep, sErr, bSuccess

Dim sServer, iSecurity, sUID, sPWD, sPkgName, sPkgPWD

' Get Form Variables

sServer = Request.Form("txtServer")

iSecurity =...

Hi,

Why don't you use a stored procedure with an OUTPUT parameter.

Once you have updated SoldItems you can pass a counter into a procedure that finds the MAX id and adds...