Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...

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

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

28 June 2011 Consider this file temporary and if you want to delete/rename this and the images folder, the program will just create another one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and finds a...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 the HTML DOM. It is similar to a "map" or "heirarchy" of the Webpage, as shown here: *Image is from this website, which is another great resource for learning Javascript. In the image above, note the document object - you will be using this object quite...

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

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose the decimal...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 Procedure I already wrote an article on this so please refer to SSRS Parameters in Oracle Stored Procedure. Oracle: Grant another user permissions /* on the table: ssrs_audit_table */ CREATE OR REPLACE PUBLIC SYNONYM ssrs_audit_table FOR...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use...

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

Print Directory Contents to a Filehttps://joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt another_file_in_this_folder.doc How? For Windows XP: Open an instance of Windows Explorer and click on "Tools" Select "Folder...

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

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

09 November 2012 the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar alongside and now copy events over by dragging and dropping (TIP: I right-click and hold and drag and this then...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...

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

Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as...

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

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

04 March 2013 (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting...

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

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

14 March 2013 (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 a long time to figure this and it was only by trawling through columns that someone...

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

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

12 April 2013 use parentheses? Then it wouldn't be 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...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

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

14 May 2013 ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe Tape-Monkey 8475 Table: DMExtractReferenceTable ------------------------------ ID MapIn MapOut 1 0011 71 2 8475...

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