SQL Queries for Statisticshttp://mail.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Parameters not being used in report processinghttp://mail.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: --...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 Can you print any other documents? Have you tried printing to another printer? Can you print from any other applications to that printer? When did you last print successfully? How/where to advertise: Word of mouth Yellow pages Local business directories...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Run commands for Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 under a folder (relative) Const SHGDN_INCLUDE_NONFILESYS = $2000 ;// If Not set display names For shell name space items that are Not in the file system will fail. Const SHGDN_FORADDRESSBARConst = $4000 ;// For displaying in the address (drives...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportID uniqueidentifier NULL The ID of the report (looks like a...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

AutoHotkey Format Date and Format Secondshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Fun with DllCall in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

MySQL last year week month day trend periodshttp://mail.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Zero Paddinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Basic Oracle Stored Procedure Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 bit of a bugger as you need to do a few other things to see the results of this stored procedure. The following are commands that I would run to view the results of the above example: VARIABLE myResultSet REFCURSOR; EXEC...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 found in the first query. The stored procedure compiles successfully and without any warnings. So What? The problem is that if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 work in" as you have for your 1.5 website. The above script ignores your previous settings and leaves the factory settings that come with the JComments extension. Check all JComments settings are what you want using the Joomla Admin interface. If the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Print Directory Contents to a Filehttp://mail.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 Notes: This outputs the contents to a text file called "directory_printout.txt". This file will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 crude, but this script works perfectly for what I had in mind. Important! There are a few concealed features of this script that I haven't made a song and dance about but are noteworthy: The only anti-code injection facility in this example is the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Vertically align an asterisk on a linehttp://mail.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2 they would in fact be...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 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 DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB