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 NULL G ELSE LTRIM(RTRIM(MMD.RateDescription)) END) AS "RateDescription" FROM tMultiManualData AS MMD WHERE MMD.BatchTypeID = ) AS MM) AS MM1 WHERE MM1.Rent IS NOT NULL " AND MM1.Rent <> 0) AS MM2) AS DCMM SELECT SequNo FROM tDCMM_Temprjc2006 ORDER BY SequNo DESC SequNo INSERT INTO tDataCollection - (SequenceNo, ServiceID, GSTFlag, AmountExGST, + GSTAmount, AmountIncGST, FromDate, ToDate, RateDescription, BatchID, TransactionTypeID) P SELECT CAST(SequNo AS varchar) AS "SequenceNo", ServiceID, GSTFlag, AmountExGST, BatchID, TransactionTypeID DROP 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 DCMM UPDATE tMultiManualData SET FromDate = NULL WHERE BatchTypeID = AND FromDate IS NOT NULL AND DATALENGTH(FromDate) <> 10 SET ToDate = NULL AND ToDate IS NOT NULL AND DATALENGTH(ToDate) <> 10 U3Uh% d0d 3ZYYdh, ]Ã- m j0j j 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$ 2 j "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$ 2 j "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$ 2 j "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 6 D, >VHVBV> <$4@@ P j P $h2 P j P $h2 P j P $h2 < < !> n Ha j 0lDpln9n
a