Prefix Line Numbers in a Text Filehttp://mail.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code....

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• 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 of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep!...

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

Basic Joomla 2.5 Mootools Formhttp://mail.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 -- add subfolder if this is not in the root of the domain: -- eg. http://demo.joellipman.com/joomla25/ has file in -- -- also note that this form can work with simply the core mootools script -- but does not include the validation that is in the more...

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

Slideshow div layer through a windowhttp://mail.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and compatible with smartphones.(Like Flash back in the days of Macromedia Flash :c) and works with apple...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• 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 can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE:...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 the recurrence rate. Sharing is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also add to the calendar quite easily as we used to use an Outlook Shared Calendar before. We see leave announcements as well as...

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

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...

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

Error 1065: Query was Emptyhttp://mail.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of...

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

Upgrading a Joomla 1.5 module to Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 in reality but you replace the name "moduletoupgrade" with whatever you're upgrading and follow the below instructions. I'm also going on the basis tha. Basic Checklist Download all J1.5 files to one folder:...

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

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://mail.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein matched the TNSNAMES.ORA file located in "C:\ORACLE\product\11.2.0\client_1\network\admin"....

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me...

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

Country Lookup by IP address CSVhttp://mail.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script. The Download...

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

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified Responses: "In the Excel connection you cannot skip Nth...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 Stage 1: Add Relevance [Mandatory Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the...

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

T-SQL Conversion failed when converting the varchar to data type inthttp://mail.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal string. So here's some ok code but it will fail if my reference data has a non-numeric value in it: -- Initial...

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

htaccess Rewrites SEF URL and submits to PHPhttp://mail.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 ErrorDocument 500 /error/?v=500 Additional Notes If you do apply the above to your site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /G Allows the copying of encrypted files to destination that does not support encryption. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy files. Does not include empty directories...

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 "where" clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the...

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

SSIS Multiple Lookups in onehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 LEFT JOIN [sourcedb].[dbo].[lookup_ethnicities] f ON x.student_ethnicity_code=f.lookup_ethnicity_code Note this also allows NULLs so, our sequence identifier and student reference are never blank so it is safe to to use "Lookup Match Output" as rows...

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