help..

Thanks for the response...

Here Michael has total 26 Business points for his total trips and based on that he should get 6 promotional points for the first 20 business...

Thanks .....

I am trying to do the same with Self Join.Can someone help me out...

CREATE TABLE Test 1 (Id1 Varchar(10), Id2 Varchar(10))

INSERT Test1 SELECT 'A','B'

INSERT Test1 SELECT 'B','C'

INSERT...

thanks for your help....

No..thats the only one I have....

Thanks

No..thats the only one I have....

Thanks

No..thats the only one I have....

Thanks

Sean,

I even tried with the real datatype and it was showing same error.

Thanks.

Thanks Sean for the response.

Actually in the column "DunnageBF" I am having the first two rows as 'NaN' data and remaing all rows with zeros.Because of this data i...

Thanks Paul...Will go through it...