ئhG~)veC 10) THEN NULL, ELSE MMD.FromDate END) AS "FromDate",J (CASE WHEN (MMD.ToDate IS NULL OR DATALENGTH(MMD.ToDate) <> 10) THEN NULL( ELSE MMD.ToDate END) AS "ToDate",h (CASE WHEN (MMD.RateDescription IS NULL OR DATALENGTH(LTRIM(RTRIM(MMD.RateDescription))) = 0) THEN NULLG ELSE LTRIM(RTRIM(MMD.RateDescription)) END) AS "RateDescription"FROM tMultiManualData AS MMDWHERE MMD.BatchTypeID = ) AS MM) AS MM1WHERE MM1.Rent IS NOT NULL"AND MM1.Rent <> 0) AS MM2) AS DCMM SELECT SequNoFROM tDCMM_Temprjc2006ORDER BY SequNo DESCSequNoINSERT INTO tDataCollection-(SequenceNo, ServiceID, GSTFlag, AmountExGST,+ GSTAmount, AmountIncGST, FromDate, ToDate, RateDescription, BatchID, TransactionTypeID)PSELECT CAST(SequNo AS varchar) AS "SequenceNo", ServiceID, GSTFlag, AmountExGST, BatchID, TransactionTypeIDDROP TABLE tDCMM_Temprjc2006"Saving Call to tDataCollection ...'FROM (SELECT MM1.Call AS "AmountExGST",: (MM1.Call / MM1.Total * MM1.GSTAmt) AS "GSTAmount", MM1.*WHERE MM1.Call IS NOT NULL"AND MM1.Call <> 0) AS MM2) AS DCMM#Saving Other to tDataCollection ...(FROM (SELECT MM1.Other AS "AmountExGST",; (MM1.Other / MM1.Total * MM1.GSTAmt) AS "GSTAmount", MM1.*WHERE MM1.Other IS NOT NULL#AND MM1.Other <> 0) AS MM2) AS DCMMUPDATE tMultiManualDataSET FromDate = NULLWHERE BatchTypeID = AND FromDate IS NOT NULLAND DATALENGTH(FromDate) <> 10SET ToDate = NULLAND ToDate IS NOT NULLAND DATALENGTH(ToDate) <> 10U3Uh%d0d 3ZYYdh,]Ã-mj0jj 8 ^Z jT jT ^`  j j j$ j j j j$j 8j 8j 8Nj j :<j > j j :<j > j j :<j > "( j j,j @*4j 0 j$(f j$(f jT ^` jjB&j j j j j j j jj jjB&j j j j j j j j j j j j j j j jjB&j j$ j j j$2j "DF04j 8 j j j j j j j j j j$ j$ jT ^` jjB&j j j j j j j jj jjB&j j j j j j j j j j j j j j j jjB&j j$ j j j$2j "DF04j 8 j j j j j j j j j j$ j$ jT ^` jjB&j j j j j j j jj jjB&j j j j j j j j j j j j j j j jjB&j j$ j j j$2j "DF04j 8 j j j j j j j j j j$ j$ j j,j @&j j$ j j,j @&j j$6jHJLN P=h Ph 6D,        >VHVBV>  <$4@@ P       j               P     $h2            P       j               P     $h2            P       j               P     $h2             <    <  !> nHaj0lDpln9n  a