There was something newer than the 360? :) "I don't want more choice. I just want better things!" - Edina Monsoon

I am afraid you missed the point of the question, as well as of the first part of the solution. Maybe you can come up with the second half of the solution: an effective loop termination condition. Please keep in mind that so far no programming language or framework has been specified, and numeric variables have whatever capacity is required... And before you object, yes this topic should have been posted in Algo&Math forum rather than here. :) Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }

Thank you very much:):):) Regards, Arun Kumar.A

Hope you get the spyware killed :D //Johannes

the best soultion is create a cursor and put cursor in stored procedure(SP) , finally call SP ------------------------------- declare @vdd bigint declare C1 cursor for Select distinct id from pdata open C1 drop table #temsales CREATE TABLE #temsales ( col1 bigint, col2 datetime, col3 bigint ) fetch next from c1 into @vdd while @@fetch_status=0 begin insert into #temsales select top 5 * from pdata where sales>0 and id =@vdd fetch next from c1 into @vdd end close c1 deallocate c1 select * from #temsales ;)

Dave Kreskowiak wrote: You might want to look in the Event Logs to see if these is any more information about the crash. Thank you very much. I will look at it. Regards, Arun Kumar.A

In RegEdit click the Edit/Permissions menu. Trinity: Neo... nobody has ever done this before. Neo: That's why it's going to work.

Thank U very much. It is working fine now. Regards, Arun Kumar.A

It is working. Thank U very much. Regards, Arun Kumar.A

Thank U very much. I will try it out and let U know. Regards, Arun Kumar.A

Have you been successful yet? I'd like to see your solution if you have. I toyed with this for a couple of minutes, but quickly realized that your algorithm can best be stated in pseudo-code like this: getCol3( rownum ) { if( 0 = col2(rownum) ) Then return getCol3(rownum-1) - col1(rownum); else return col2(rownum); } which is a *recursive* procedure. Some DBMs support recursive queries (Oracle and DB2 for instance), but I'm not sure even they would work here as they tend to recurse on *existing* field values, not on generated values like you want here. Check out the CONNECT BY clause if you're interested. I'm inclined to think Colin is correct here; I SERIOUSLY doubt this can be done without procedures. I have similar requirements in my tables, but have resigned myself to putting the table updates into loops within code. Let us know if you do figure out a clever way. Good luck. David

Thank U very much. Regards, Arun Kumar.a

Thank U very much. I will check it out. Regards, Arun Kumar.A

Hi, Thank U for Ur reply. I will try this out. Regards, Arun Kumar.A

Thank U for Ur kind reply...

Arun.Immanuel wrote: How to identify if it is freeware? Just Google...:-D Knock out 't' from can't, You can if you think you can :cool: