Thanks allot for your replies.

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

CREATE TABLE dbo.StagingINOUT (CardNo int ,

IODate date ,

IOTime time (7),

IOTypeN int,

DATETIME datetime)

If any other information is required, please let me know.

Waiting for the better solution

Thankyou