Ken,

Your query is giving almost exact output. But only thing is ID number has to regenarate each and every transaction type code.

Regards

Karthik

Jeff,

I spoke to my RM (Reporting Manager) and he did not accept it 

he wants to populate the data as i mentioned format only.

Please...

David,

----------------------------------------------------------------

SELECT @CompanyInstitNbr = CompanyInstitNbr,@Seq = Seq, @ValueDate =ValueDate

 FROM #Tranches

 WHERE Seq = (SELECT MIN (Seq)

  FROM #Tranches

  WHERE Seq > @Seq)

-----------------------------------------------------------------

This part is using RBAR logic. Am i correct ? if not please...

In this query value date calculation is very important.why ?

InstitNbr     VAlueDate    Amount

232           07-sep-2007   5000

232          08-sep-2007    6000

232          09-sep-2007    1000

Then we need to calculate

232 - 07-sep-2007 amount value is 5000

232 -...

any comments or suggestion ?

Yes both servers returning the exact result.

Both server has the same configuration ,whatevere you mentioned in your post. But i dont know why the server2 is taking long time to execute the query ?

Thanks John.

I have executed SET IMPLICIT_TRANSACTION ON statement. It is executing fine.

Can you explain me the internal working structure of IMPLICIT_TRANSACTION ?

Regards

Karthik

Hi Experts,

Please give me your valuable suggestion and Comments about my code.

I am very interesting to hear some suggestion and comments. Because i will change my coding style in future.

Regards

Karthik 

Experts,

Thanks a lot for your proper answers !

Karthik

Ok. I will pay up.

Bless me to get party from them in future.

Regards

Karthik

Marcus,

is it possible in sybase database too ?  because some co - workers areworking in sybase db. if not possible i will not arrange.

When i increate my table count in the where clause , will it affect query performance or not ?

I have written it just for fun.

Please tell me , is it possible to create System procedures or not ?

Regards

Karthik

David,

Is it possible to create it ? Really i want to know , I dont know whether you take my words as fun or not. 

Regards

Karthik