Hi,
i have 4 columns in lossrun table in sql server named policynumber,effdate,premium and losstype. My requirement is if there are same values for effdate and policynumber in 3 columns then the premium values has to be dispalyed only for first row and all the remaining rows should display zero.there are 3 columns repeating with the same policynumber and effdate is because of different losstype
Note:the same effdate and policynumber in single column present having a single losstype should display the premium value as it is. no change in it
thank you