Difference between revisions of "SPBilling"

Revision as of 14:03, 15 March 2016

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

Open SQL Yog connect to 89 server
Run this query
Remember changes the date do you want to remove the balanced.
SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'

@@ Line 1: / Line 1: @@
+== Remove Maintenance previous balance ==
+# Open SQL Yog connect to 89 server
+# Run this query
+# Remember changes the date do you want to remove the balanced.
+# SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
+# UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'
+== Remove Water previous balance ==
+# Open SQL Yog connect to 89 server
+# Run this query
+# Remember changes the date do you want to remove the balanced.
+# SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
+# UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE  dtencoded >= '2016-03-10'
+== Remove Maintenance previous balance ==
+# Open SQL Yog connect to 89 server
+# Run this query
+# Remember changes the date do you want to remove the balanced.
+# SELECT * FROM spbilling.tblmbilling WHERE dtencoded >= '2016-03-10'
+# UPDATE spbilling.tblmbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE dtencoded >= '2016-03-10'
+== Remove Water previous balance ==
+# Open SQL Yog connect to 89 server
+# Run this query
+# Remember changes the date do you want to remove the balanced.
+# SELECT * FROM spbilling.tblwbilling WHERE dtencoded >= '2016-03-10'
+# UPDATE spbilling.tblwbilling SET prevbal = "0.00", prevpenalty = "0.00" , prevpmt = '0.00' WHERE  dtencoded >= '2016-03-10'
 == Remove Maintenance previous balance ==