Hi All,

I am trying to re-write the query with all your suggestions. I think am almost there, only last join condition is not working. Below is what im...

Thanks Luis, Scott, Thom, Grant for all your Suggestions !!!
I will follow all your suggestions . I think, instead of making changes to this stored procedure which is...

Hi Thom,

Thanks for the info !!!
You mean even if i attach it as a file , if you open the file in your machine, will it still...

Hi Luis,
Thanks very much for the advise !!!
 I will modify the cursors and joins as per your suggestion and Thom's.

Hi Thom,
I am trying to format...

Hi All,
Based upon the suggestions provided I have created tables and given appropriate foreign keys. 
Also I have given the datatypes for columns based on below consideration :

Thanks for the clarification Scott !!

Hi ,

I am in the process of designing the new tables as per the suggestion provided, I have one doubt... is it essential to have keys for staging...

Hi ,
Based upon the advise provided , I have designed the new tables.
Basically my application is going to get two feed daily for ledger purpose. One which contains...

Thanks ScottPletcher,  Roger.plowman  !!!
I will follow your suggestions and hope it will be good learning experience for me