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

14 December 2011 One Issue The report will always load when opened defaulting to having all parameters set to the dummy value. For me it just opens an empty report with the charts saying "No Data Available" but I find this better then the alert message "parameter cannot...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

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

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

16 January 2012 Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to...

• 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 Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

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

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 yet available D300 4 Daat oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE...

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

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

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

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 and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the...

• 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 gives 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: *

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Important Note: The ID it installs with is for my demo site. If you want to reset the visitor count and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For example:...

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

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

11 January 2013 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 clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task:...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• 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 "It is not possible." I am shocked at how responses to this and opinions vary between "Microsoft Certified Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 come before Mondays... but what's wrong with this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong...

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

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 002 3.00 2000-02-18 1.00 2 002 3.00 2000-02-18 1.00 3 003 2.00 1999-02-25 1.00 1 003 2.00 1999-02-25 1.00 2 Great! Now let's just add the Rownum value to the date of sickness (minus 1 for obvious reasons - 25th + row(1) = 26th when the person was off...

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

Compare two databases using T-SQLhttps://www.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM...

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

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 which other packages import as a Custom Component Script. (ie. if we use this script in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my script (or more like an experienced...

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

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

15 November 2013 you have been directed to this page, this is a draft article on a standard development project. The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 :: :: Logging Options : :: /L :: List only - don't copy, timestamp or delete any files. /X :: report all eXtra files, not just those selected. /V :: produce Verbose output, showing skipped files. /TS :: include source file Time Stamps in the output. /FP...

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