Ken,

When i tried to execute the select query, It took around 3 mints to execute and getting the following error.

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting...

Thanks allot for your replies.

I can provide you the definition of stagingINOUT table's Definition.

CREATE TABLE dbo.StagingINOUT (CardNo int ,

...