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

05 August 2014 JOIN [sourcedb].[dbo].[lookup_genders] b ON x.student_gender_code=b.lookup_gender_code LEFT JOIN [sourcedb].[dbo].[lookup_countries] c ON x.student_country_birth_code=c.lookup_country_birth_code LEFT JOIN [sourcedb].[dbo].[lookup_countries] d ON...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 two letter country code (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Sir James Dyson explains his bladeless fanhttps://www.joellipman.com/articles/_other-misc/sir-james-dyson-explains-his-bladeless-fan.html

30 October 2009 of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other countries but this is definitely a step in the right direction. {youtube}6A3IM06xgr0{/youtube}

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 Propagation includes copying, distribution (with or without modification), making available to the public, and in some countries other activities as well. To “convey” a work means any kind of propagation that enables other parties to make or receive...

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

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

17 March 2013 but this was so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 (per month per year) Days of Month (per day this month) Days of Week (per day this month) Hours (per hour this month) Countries (Top 25 this month) Hosts (Top 25 this month) Robots/Spiders (Top 25 this month) visits Duration (this month) Pages-URL (Top...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different to "rivière". We need to...

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