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

07 November 2011 local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not...

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

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 This is to be applied to the "Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" is the field to compare (of all "Data_Retrieval" values) and "Report1" is the...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field...

• 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 work slightly differently and are easier to pull off. After much umming and aah-ing, I have written this article as a note for me to demo a working stored procedure and how to use cursors. I'm told I need to use this for SQL Server Reporting Services...

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

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 This errors when the student does not have a username. No rows are returned for the first query and a zero isn't inserted. Note: Running just one of the queries will work as normal with the NVL function. Running the second based on the first will error...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Now we can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 myTable2.DisabilityCode 1 DyNa myTable3.EthnicityCode 1 DñYà myTable3.OriginalSurName 1 DNYA myTable4.RegionCode 4093 -- note how it picked up DyNa as matching DNYA. -- values it did NOT pick up were words like "dayname" and "dynamite". Additional Notes...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from...

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

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

09 November 2012 you other options as well as the "copy"). Where's the automation? All-Day Events We use this for leave and this is just a note to say I had to amend the event using Outlook 2007 to tick the checkbox declaring it an all-day event. Recurring Events...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there...

• 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 So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...

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

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 This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...

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

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

05 February 2013 section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote...

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

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

17 March 2013 a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script....

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

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

04 April 2013 column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the first column of the data sheet (eg....

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