Hi gail

that seems to have done it

9secs!

Can you give me an explanation of the code?

Thanks

Johann

Hi gail

that worked!

I am getting the correct order in the select

table def

create table #temp

(

[Id]int IDENTITY (1, 1) NOT NULL ,

[langCode] char(6),

[projectid] int,

[status] int,

[Order] int

)

As for sample data, its the one I posted before.

Is this enough or shall i give you...

Hi Sandy

Yeah but I need to compare the row from the select to the current row

If I do a select before the While, how can i get row by row...

I agree that I have to move away from the cursor, since its too much processing time!

However I cannot see how I can do your example with my procedure Sandy.

I...

Hi gail

I am definetly using SQL 2005

hi Sandy

But I want to check on criteria, if projectid or langcode changes

Hi Gail

so here is an example

input:-

ID langCode ...

Hi Sandy

Can you show me how to do that?

Thanks

got it!

update #tempTable

SET fk_langid =

(

--SELECT lid,

CASE

WHEN lid like '%sr%' THEN '1234'

END

--FROM #tempTable

)

Thanks

Seems like the important thing is that the PageID > 0, that is why I am ordering in

ORDER BY PageID DESC, Status ASC

thanks for your help guys

I clarified with my project leader

this is enough

ORDER BY PageID DESC, Status ASC

The rows that are not ordered, will be listed after the ordered rows

So the resultset should look something like this:-

ID ...

Hi I solved this

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[sp_getpageidsforedb]

@projectid int

AS

SELECTROW_NUMBER() OVER (ORDER BY e.StringID) AS IndexID,

e.StringID,

e.Trans,

e.Status,

COALESCE(s.PageID, 0) AS PageID

FROMeDBs AS e

LEFT JOIN(

SELECTStringID,

MAX(PageID) AS PageID

FROMStringIDsInPages

GROUP BYStringID

)...