What can you do when you have different timetable
-
Here is a situation: we have few customer who take international calling service from us. well, for all the customer there is a common rate table. but there is other 10 + customer who has their won rate table, they got cheaper service. so the genius engineer developed that code in VBA: the code is something like below:
SELECT * FROM commontimetable WHERE CustomerId <> 'Customer one' AND CustomerId <> 'Customer tow' AND .... CustomerId <> 'Customer ***'
and then for all the customer with own time table get their own query and when a new customer get added with different rate table I had to add another AND + condition I wish I was smart like him
-
Here is a situation: we have few customer who take international calling service from us. well, for all the customer there is a common rate table. but there is other 10 + customer who has their won rate table, they got cheaper service. so the genius engineer developed that code in VBA: the code is something like below:
SELECT * FROM commontimetable WHERE CustomerId <> 'Customer one' AND CustomerId <> 'Customer tow' AND .... CustomerId <> 'Customer ***'
and then for all the customer with own time table get their own query and when a new customer get added with different rate table I had to add another AND + condition I wish I was smart like him
I totally agree but I've worked in environments where that is the best option. 1. KPI is based on the number of tasks completed. In which case this would have been the quickest resolution. 2. Only implement the requirements. Nothing more. Nothing less. It's sad but true that in some environments, adding a flag to the database schema and a check box to the UI, can lead to problems. Unless that was specifically requested.
"You get that on the big jobs."
-
Here is a situation: we have few customer who take international calling service from us. well, for all the customer there is a common rate table. but there is other 10 + customer who has their won rate table, they got cheaper service. so the genius engineer developed that code in VBA: the code is something like below:
SELECT * FROM commontimetable WHERE CustomerId <> 'Customer one' AND CustomerId <> 'Customer tow' AND .... CustomerId <> 'Customer ***'
and then for all the customer with own time table get their own query and when a new customer get added with different rate table I had to add another AND + condition I wish I was smart like him
Isn't there a table, where you can get all the Customest with own timetable from? Then you could use a sub-select instead of coding it hard. When not: bad database-draft, when yes: bad select-query. :)
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Isn't there a table, where you can get all the Customest with own timetable from? Then you could use a sub-select instead of coding it hard. When not: bad database-draft, when yes: bad select-query. :)
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
That's what I did, I updated the system. Where each user has a timetable name. if there is different then I put the different table name, I put this on customer basic info table.
-
That's what I did, I updated the system. Where each user has a timetable name. if there is different then I put the different table name, I put this on customer basic info table.
:thumbsup:
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.