Actaully I have source table that is having value either null,0 or 1 and I am selecting that column for my one of column query source.
- In the destination column whenevener I will see null value for source then i want to convert into varchar value with -1 and for the 0 and 1 i don't want to change anything i want to keep their value as it.Can you help me
Query I have tried looks like this
select PD.DateId,PD.OpportunityId,Opp.CustomerRelationshipNbr,PDS.SellingCompanyKey,PDR.ResourceCompanyKey,PDSG.ServiceGroupGrowthPlatformKey,PDLC.LocationKey,PDLCI.LocationKey as Worklocationkey,PDLB.JobLevelBillCodeKey,PDCS.CapabilitySpecialtyKey,PR.NegotiationMethodId,PDRC.RateCardKey,PRRC.RevenueRecognitionKey,PR.OnshoreOffshoreInd,
WHEN Null THEN
PD.RevenueDecoupleCd = '-1'
WHEN '1' THEN
When '0' Then
Can yoh help me for above decoulecd
View Complete Post