Michael had a good point. But you can do it without a while loop. Using a temp table is fine, but can give you some performance problems when dealing with...

I found 2 solutions. The first select will not give you the row with the null value, but should perform better, the second gives you the result you want :

use...

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...