Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 (in my example: p_STUDENT_ADNAME). Under "Parameter Value" type the exact same name of your SSRS parameter prefixed with a square bracket and the at sign and then suffixed with a closing square bracket (in my example: [@StudentReference]). 4d. Add a...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 ≈ almost equal to 248 F8 U+00B0 ° degree sign 249 F9 U+2219 ∙ bullet operator 250 FA U+00B7 · middle dot 251 FB U+221A √ square root 252 FC U+207F ⁿ superscript latin small letter n 253 FD U+00B2 ² superscript two 254 FE U+25A0 ■ black square 255 FF...

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

Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 1 banner at a time. If you want other categories to display, consider setting categories as vertical, horizontal and square banners. This means that you can have 3 modules each displaying banners from each category and position these as appropriate.

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

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 and BIDS will add the parent group we added just before. You can now right-click on 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...

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and...

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

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

07 July 2014 you want the carriage return and press Return/Enter. This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday,...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 see what custom options you already have. By default you should have one called "wallpaper": /imagine a flower // returns 4 square pictures of a flower /imagine a flower --wallpaper // appends "--w 1920 --h 1024 --hd" // returns 4 pictures of a flower...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 = ""; v_Logos_PartnersHTML = ""; // // the generic signature for all users with merge fields enclosed with square tags: v_RecodedSignature = " [AB-StaffName] [AB-JobTitle] [AB-MobilePhone] [AB-Email] www.joellipman.com " + v_Icon_TwitterHTML + " " +...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 then on the sub-tab "Image", and click on the button labeled "Choose Image": I'll select "My Library" and click on the square with a plus sign on it to select images from my device: Now I can select the image(s) I want to upload (unfortunately only 1 at...

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