hello all,
i have query where i wll get the details of points and one Profile ID will have for example 2000 points in this regard application prespective if he look on another profile 20 points will be reduced and count will 1980 and if he like on another profile another 20 points
My output like be this
[CODE]
ProfileID Profilename AllotedPoints ReducedPoints
1011 Mohan 2000 20
1011 Mohan 1980 20
1011 Mohan 1960 20

Hello visakh here to do minus i dont have a column of reduced points, IN your above query i have modified and used to my present requirement my query is look like this in that one table Cust_ExpressIntrestLintStatus will look for profileID and Cust_CheckoutLimits gives you point and i need to reduce 20 points how i can reduce the 20 points dynamically