... other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results:
SELECT ...
... worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report.
One Issue
The report will always ...
... milliseconds between start and end times instead of summing the remaining columns?
Correction, sum will only give me the total time but what if a report has been run twice more often then another, then ...
... Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference" but not necessarily a student AD account (enquired/applied ...
... date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget ...
... pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill > BackgroundColor" ...
... want to add new 3rd-party components.
If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing ...
...
Click on the "Save" icon.
Click on the install button in the same row as phpBB Forum.
Click on the remaining "install" buttons
Test
Now go to the front-end ...
... make sure it remains free software for all its users. We, the Free Software Foundation, use the GNU General Public License for most of our software; it applies also to any other work released this way ...
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.