How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 yields // Time Taken: 2.15443570 second(s) // I don't have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 example: VARIABLE myResultSet REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet; Should yield something like: MYRESULTSET --------------------------------------------------------------------------------...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS should copy over to your local folder; once done close the dialogs click on the TFS icon in Source Control Explorer and check...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string...

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

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

19 July 2012 with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)". If there isn't create a New "String Value", name it "(Default)" Double-click this...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Added a dummy index to track row numbers. Copies structure (column_name, data_type, character_maximum_length) Copies data (should be exact copy)

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 'JPATH_BASE', realpath(dirname(__FILE__).'/../..' )); // print this out or observe errors to see which directory you should be in (this is two subfolders in) define( 'DS', DIRECTORY_SEPARATOR ); require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php'...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 For those of you who are familiar with this, I am simply using an alternative to the DATE_FORMAT() function in mySQL. Should yield: AcademicWeek Mon Tue Wed Thu Fri CalendarWeek -------------- ----------- ----------- ----------- ----------- -----------...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 - these are the database and login credentials. $ftp_user and $ftp_pass are the ftp credentials. $log_path and $tmp_path should also be updated. $robots - set this to 'noindex, nofollow' (we don't want google to index our test site). Disable new user...

• 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 throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the remainder when it should be discarding it.

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

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

27 January 2013 the data $rows = $db->loadObjectList(); echo $my_count; -- If you try to retrieve the data before doing the count, you should get the following error: Warning: mysql_num_rows(): 80 is not a valid MySQL result resource in...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 in a sort of reversed form. For argument's sake, I'm assigning this string to the variable "haystack". How? Perhaps we should determine the position of the last needle first (reverse the haystack string and find needle): DECLARE @Haystack VARCHAR(31);...

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

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

03 February 2013 @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET @stringtoReplaceWith=' ';...

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

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

04 March 2013 was written for those that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work...

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

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 datasource component so that it's selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above:...

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

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

23 April 2013 the data column to accommodate for the special characters the blank rows somehow feed in. In this case, the Ragged Right should go to the next {CR}{LF}: The Data Flow from file to valid columns: Flat File Source: Ignore failure on Truncate, Output...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 files and then a copy with my modifications above. I use this to quickly add the relevance option to clients websites as it should work for all Joomla installations version 3.4.x. Download demo files

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 without the quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the...

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

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

24 May 2013 -- yields EmployeeNo QualificationRef -------------------------------- 001 00101 001 00102 002 00203 -- Wrong! This should start from 1 for another employee. 002 00204 003 00305 Almost There! So we're using the ROW_NUMBER() functionality with an ORDER...

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

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

15 November 2013 is included in the initial development. Service Transition will happen over the course of 1 month where the client's team should be made available to receive manuals and training on how to manage their website. A support agreement is drawn up with...

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