The default is not read-only. In Bol, you will find for the read-only option :

"READ ONLY

Prevents updates made through this cursor. The cursor cannot be referenced in a WHERE...

Can you tell us what type of cursor you use ? global/local, read-only, .... I suppose a cursor that is NOT read-only has more performance problems with an order-by then...

You are right. We'll have to wait for a more detailed explanation. A cursor will be probably the easiest way to solve this, but I do not like cursors ......

For me it works fine

INPUT :

and after the update :

Please try this :

set nocount on

create table dbo.tst(PersonID varchar(30) not null, adate datetime not null, anint int null )

insert dbo.tst (PersonID,adate) values ('A','20040101')

insert dbo.tst...

when calling a UDF, you should at least mention the owner of the function. Something like this should work :

insert into @table select * from dbo.fn_splitstring(@strings)

Please try this :

use tempdb -- for testing

go

create table dbo.bid     ( aut_id int primary key, bid_price money )

create table dbo.aut_attr ( aut_id int primary key, min_bid_price money )

go

insert dbo.aut_attr values...

I would propose to add an optional parameter to the 2 procedures, and make them insert the results of the select in a temporary table. I would use the fact...

You should verfiy if you use returnAverages in your scripts. It may be a stored procedure you forgot to script. Look for the procedure on the original server and create...

Hi, I wrote this stored procedure and test script. The stored procedure installs into the master database, so you can use it in every database. Hope this will help you...

I also tested this with SYBASE ... and SYBASE gives the same result as ORACLE ...

I also tested this on SQL SERVER 2005...

Hi Andy,

I have some questions  :

- Can there be multiple games for 1 UserId in the table ? And if so, should the procedure only list the score of the...

I have just 1 remarks. It is not true that ALL SQL servers are listenig on port 1433. 1433 is just the default value. My production servers are not listening on...

when the context is already pubs then everything goes ok !

You can build the HTML for the second option box in a string and write the contents of that string afterwards ....