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

05 November 2012 v1.0 ** ** Description: 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...

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

Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

03 August 2012 go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values...

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

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

11 January 2013 all sessions dated after February 1st 2013 -- and all related records (linked by ID) in relevant tables. Delete from specific tables but not all Simply don't refer to the table after the DELETE clause. Rather straightforward but I got this answer from...

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

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

05 February 2013 File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your LIVE/production database). Click on the Data Import/Restore link in the left...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

16 May 2016 } }(document,"script","twitter-wjs"); Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/cms/website-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first time(s) you do this,...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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

SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

20 January 2014 "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.

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

MySQL Oracle equivalentshttps://www.joellipman.com/articles/else/database/mysql-oracle-equivalents.html

27 September 2010 in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM

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