SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the top of the [Order] column (grey square -like excel- to select the column). Select "delete columns". Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your report should look...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row -...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 The program is built with what I call help 2.0. Visit the Help page in the program and it will check a few things to make sure it works on your computer. I've specified that that's all it scans for, it's not interested in your personal details or what...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 this is a program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network....

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

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

24 January 2012 Rectified part of the stored procedure: The solution in the end was to null the first query and make sure it didn't return the errors "no data found" and send this to the second query: -- the same query but which doesn't fail the procedure :) SELECT...

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

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

20 August 2012 1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less - Not 100% sure about this but I tried the example in the Official Joomla Documentation and I couldn't get it to work. They even add a note to say...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 in width fixed the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but I'm not 100% sure this fixes the issue throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the...

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

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

22 July 2013 NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

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

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

23 August 2013 If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing....

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 trailing space ValueToConvert = ValueToConvert.Trim(); // Use a method to set the value of each String type property // Make sure the length of the new value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) {...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared...

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

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

03 November 2013 after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings >...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 name box. (This file is a system-hidden file, so it won't show up in the file selection window. You have to type it in. Be sure not to select ntuser.dat.log by accident.) Click ok, then enter a name for the key. We'll call it Foo. Go to...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 domain. Why? I warned that a 301 site gets removed from the Google directory and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file:...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 fjs.parentNode.insertBefore(js,fjs); } }(document,"script","twitter-wjs"); Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px in width but this is not good for a final solution. I thought...

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

Zoho Deluge - Get distance between two coordinateshttps://www.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be...

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