I think, This gives you some idea :)))

declare @Table table (Doc_Nbr int,Ticket_Nbr int)

insert into @Table values

(12,907),

(12,908),

(12,909),

(12,913),

(12,915),

(12,919),

(14,1481),

(14,1484),

(14,1485),

(14,1486),

(14,1487),

(14,1489),

(14,1490);

WITH C AS(

select Doc_Nbr,Ticket_Nbr,DENSE_RANK() OVER (PARTITION By Doc_Nbr ORDER BY Ticket_Nbr) as rownum

from @Table

)

select *...

I think, If you would use SQL Server 2012, here are some new functions lag and lead which will help you.

I want to write an iterative query with resetting counter if backup succeeed?

I achive this with Cursors but, i want to learn to do this with an iterative SQL Statement?

Thanks again, I am still reading Kalen's book, and tring to understand concepts.

New question:

Can i see all pages in a database with a command like DBCC IND?

OR

How can see...

Thanks All,

New questions:

If there is a mixed extent, Must it contain a Shared Global Allocation Map (SGAM) Page and Page Free Space (PFS) Page?

And

When a new extent will be...

How many CPU Does your node have?

Thanks a lot

Thanks a lot

To optimize the query

Yes but, i must provide referantial integrity

I have same problem,

While updating AS 400 files message below is shown:

Server: Msg 7344, Level 16, State 2, Line 1

OLE DB provider 'MSDASQL' could not UPDATE table '[AS400_IZM].[S6503FBC].[PRDLIB].[PRODPLN]' because of...