Hello Again Dwain

Sorry for my late answer, I've on vacation in Greece for one week.

What i mean is there an better alernative for CURSOR.

What i want to do is following:

...

Here is some Data For bo_MatchTest and MatchResultTest

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[bo_MatchResultTest](

[MatchResultMatchId] [int] NOT NULL,

[MatchResultLicNbr] [nchar](20) NOT NULL,

[MatchResultTeamId] [int] NOT NULL,

[MatchResultShirtNo] [int] NOT NULL,

[MatchResultRoundResult1] [int] NOT...

Hello again Dwain

Is ther an other or better way for CURSOR

What i mean is when for ex. i want to select from one tabel and list one post

for players...

Hi again Dwain

When i was yunger i also loathe my name.

But older i get i get used to it.

My middle name is Erik.

And i´m named by an old canoeist...

Dwain Thanks a lot.:-P:cool:

Thank you all for your help.

I found an loop in .net code with no stop, therefor the server peeked.

Tanks:-)

Gert Lindholm

Hi again,

I see an SP p_getMatchSchemeNowAndNextRound with some @parm.

The thing is that @parmRoundId is werry high number.

From our .NET solution i have an max of 30 i RoundId. but here...

I find this at MSDN:

SELECT TextData, Duration, CPU

FROM trace_table_name

WHERE EventClass = 12 -- SQL:BatchCompleted events

AND CPU < (Duration * 1000)

Where...

How do i do that?