Friday, October 12, 2018

Nested Case Condition


CASE

                                         WHEN(P.PropertyId=115)    
                                         THEN
                                         ''
                                         ELSE
                                           CASE
                                              WHEN R.CompanyId is not null and R.CompanyId>0
                                                THEN CASE WHEN R.IsSeleComContForConfi = 1
                                                       THEN
                                                       AA.Pincode
                                                       ELSE
                                                       A.Pincode
                                                       END
                                                ELSE
                                                       A1.Pincode
                                            END   
                                    END AS  [Pincode]   

No comments:

Post a Comment