This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it ...
...
Why?
Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the ...
Quick Reminder
I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query.
The Situation
We ...
... the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables).
...
... and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only access). One of the requirements was that ...
... on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks ...
So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat.
The Situation
We have an Excel report which ...
... the second solution will mean each dataset must at least join both tables that you are using the OR clause against.
There must be a solution that executes a query at report execution time and populates/assigns ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.