kiladi bullodu Posted March 25, 2014 Report Posted March 25, 2014 annaya enti idhi nee problem endo correct gaa cheappu ila output paste cheste nee inbox antha "nenu support istanu 400 $ ivvu ani untundhi " PS naaku SQL raadu ltt iloveindia ani oka id untundhi athani pm pettu
loveindia Posted March 25, 2014 Report Posted March 25, 2014 annaya enti idhi nee problem endo correct gaa cheappu ila output paste cheste nee inbox antha "nenu support istanu 400 $ ivvu ani untundhi " PS naaku SQL raadu ltt iloveindia ani oka id untundhi athani pm pettu 600$ man.... . tammuduuuu bramham.....
sri_sql Posted March 25, 2014 Author Report Posted March 25, 2014 sorry bhayya ee cursor ni marchali join ga or insert update petti if exists laaga no, adi naa condition ikkada. Requirement lo CaseID meeda depend ayi either insert or update cheyali ani undi, EE cursor chaala paathadi. Records chaala ekkuva vasthumayi ee madhya so time ekkuva padthondi. Maa mgr time taggichu or mothaniki cursor replace cheyamanadu
loveindia Posted March 25, 2014 Report Posted March 25, 2014 man , as I told u at msdn... same thing here also man.. you probably have to write this in two steps... IF EXISTS( SELECT 1 FROM ECaR.tblBKYBankruptcy T WHERE T.CaseID = @sCaseID OR (T.CaseID IS NULL AND T.AccountNumber = @sAccountNumber AND ISNULL(T.CaseNumber,@sCaseNumber) = @sCaseNumber)) first caseid ki teesko... second if lo caseid is NULL ki chudu... then it will work... let me know if you need more... .
sri_sql Posted March 25, 2014 Author Report Posted March 25, 2014 nuvvu MSDN lo kuda post esaav ga??? Ya vesanu bhayya..nuvvu ichina way try chesanu kaani row count diff vasthondi inka.. Nenu okati rasanu adi post chestha
sri_sql Posted March 25, 2014 Author Report Posted March 25, 2014 man , as I told u at msdn... same thing here also man.. you probably have to write this in two steps... IF EXISTS( SELECT 1 FROM ECaR.tblBKYBankruptcy T WHERE T.CaseID = @sCaseID OR (T.CaseID IS NULL AND T.AccountNumber = @sAccountNumber AND ISNULL(T.CaseNumber,@sCaseNumber) = @sCaseNumber)) first caseid ki teesko... second if lo caseid is NULL ki chudu... then it will work... let me know if you need more... . Bhayya problem enti antey cursor lo each and every row select cheskuntondi if exists ( Select 1 from table) chesthey adi similar gaa raadham antey ravatledu
loveindia Posted March 25, 2014 Report Posted March 25, 2014 Bhayya problem enti antey cursor lo each and every row select cheskuntondi if exists ( Select 1 from table) chesthey adi similar gaa raadham antey ravatledu I am getting confused on the OR condition of urs man... can you tell me what is the exact scenario there... what condition to check and load if not present????
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts