This might help. Let me know if you need anything more. Thanks

CREATE TABLE TableD (

ColA varchar(50),

ColB varchar(50),

ColC int

)

INSERT INTO dbo.TableD (ColA,ColB,ColC) VALUES('018102c','018102c','0')

INSERT INTO dbo.TableD (ColA,ColB,ColC) VALUES('018134C','018134C','0')

INSERT INTO dbo.TableD...

This should give some idea what i am trying to achieve, this is currently not giving the right results and i want to know what am i doing wrong. This...