T-SQL concatenate an incremental row numberhttp://mail.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 3 002 Tape-Monkey Engineer 1:0 So based on this logic, the Employee "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP...

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

Reorder Columns in a Tablehttp://mail.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that...

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

Split a row into multiple rows based on a column valuehttp://mail.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 001 1.00 1997-11-17 002 1.00 2000-02-18 002 1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask...

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

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 are not and vice-versa] and resilience [99.99% uptime] status compared to European companies). This will have an impact on some of the systems date and time operations (eg. if you get an e-mail at 2am PST from the server, this is also 10am GMT – e-mails...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Call to a member function mark() on a non-object in Joomla CMShttp://mail.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was. The error refers to a function used by the core framework. Comment it...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the...

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

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttp://mail.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First let's look at the XML output from SITS (this is a cut down version for demonstration purposes):...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 located")); } If you are prompted to import the classes then agree by clicking OK: If you are not prompted, you should see some of your code go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter,...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttp://mail.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 feed and the first two entries are " - Google News", everytime. This article documents what I did to fix it. How? Basic to some but I'm new to the game. I'm trying to remove the first two entries from a news feed from a Google News feed. Modifying the...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Test SHA1 code: Creating a Google Maps project in Android Studio (v0.8.6 beta) "creates" a SHA1 along with the project name: something similar to: 5B:3D:C4:92:CA:D5:12:89:45:1D:E2:64:CF:C8:21:F8:04:38:F2:3E;com.example.myapp. By default this is the SHA1...

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

Android: Replace return key with done, go, send...http://mail.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 // do function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No...

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

Protecting your Joomla Administrator Sectionhttp://mail.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 any third-party extensions and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in...

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

Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch1, CURLOPT_SSL_VERIFYHOST, false); $my_beautiful_body = ' --joes_awesome_divider Content-Type: application/json; charset=UTF-8 { "name": "'.$name.'" } --joes_awesome_divider Content-Type: '.$mime_type.'...

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

AutoHotkey: Check Windows Folder Sizeshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the...

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

Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If...

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

Convert Past Date to Time Ago in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3...

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