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

You can use an 'INSTEAD OF' trigger. For optimal performance, you could also store the current maximum in an other table. Example below uses select max() to get the current...

You can find the info you need in the master.dbo.spt_values table. Following script lists all indexes that will be uniqe ( unique, primary key or unique key ). I got...