Click here to Skip to main content
16,023,117 members

Comments by invisible@123 (Top 27 by date)

invisible@123 17-Aug-15 3:54am View    
thanks
invisible@123 17-Aug-15 3:13am View    
ALTER VIEW [dbo].[vwEffectiveCommUserMastIDs]

AS

SELECT MAX(CommHeirID) AS CommHeirID, BAID, MAX(WEFDate) AS WEFDate

FROM CommHeirUserMast

WHERE WEFDate <= GetDate()

GROUP BY BAID

GO

from this i get commheirid
SELECT B.CommHeirID,D.CommHeirID
FROM DBAMFDISTData.DBO.UMCommWithHeldLog A
LEFT OUTER JOIN DBAMFDISTData.DBO.UMTranImpoPendLog B ON A.TranNumb2 = B.TranNumb2
LEFT OUTER JOIN BAMASTER C ON A.SubBroker = C.CustID
LEFT OUTER JOIN vwEffectiveCommUserMastIDs D ON C.BAID = D.BAID
WHERE ISProcessed=0
and b.CommHeirID is null and d.commheirid is not null
invisible@123 14-Aug-15 6:05am View    
sir if i left join i get data,so want to update
invisible@123 13-Aug-15 7:28am View    
i want b.commheirID should contain d.commheirID value
invisible@123 13-Aug-15 7:27am View    
then what to do pls help